5 duplicate records each 1 unique field converted into 1 record?

[marlin123]

I have a database of 10,000. some people occur 5 times in the database with five different product codes. like the following:-
John Smith 23 Smith St, Smithville. bb1
John Smith 23 Smith St, Smithville. bk1
John Smith 23 Smith St, Smithville. hu1
John Smith 23 Smith St, Smithville. hu2
John Smith 23 Smith St, Smithville. pl1

What I want to do is get the database to look at the first field and if it has already occured then duplicate the code field at the end of the previous occurrance of the record. Therefore increasing that record by one field. Or even just adding that code into a code field.
Then I end up with onrecord like the below.
John Smith 23 Smith St, Smithville. BB1 Bk1 Hu1 Hu2 Pl1
Please help me if you can!!! [sig][/sig]

 

[ShortTexan]

What does the code refer to?
I think a related table is what you are talking about.