field values concatenation

[ktow...@gmail.com]

i have several hundreds of records with the duplicate email addresses in a field, but different value in another field.

such as..

unique email value new value
--------------------------------------------
yes sample_email01 a1
no sample_email02 ge
no sample_email03 a2


I want in a record with unique value 'yes' to have "a1 ge a2" in 'new value' field.

can anyone tell me how i can realize this using vba code.. I have several hundreds of records with many emails... but only about one third of unique email addresses..

with each unique email, i want to update 'new value' field with values in 'value' field with the same email.

any help will be deeply appreciated.