Macro to combine variable rows

[Help?]

I have an excel file that has several people listed several times in
different rows. The only common information that shows these individuals as
the same person is their SSN. The same individual is listed several times in
different rows due to each row showing the same individual with different
products that they have purchased. Is their a macro that will read the SSN
column - looking for the same SSN, and if the same SSN exists, combine the
information into one row?

 

[Tom Ogilvy]

perhaps a couple representative rows of data with an indication of what
columns they are in and if there are multiple products in a single row, what
you want the output to look like.

 

[Help?]

The data looks like:

Amy burden 111-11-1111 LTD
John Burden 111-11-1111 STD
sam burden 111-11-1111 CHILD
kim swafford 111-11-1112 PS 1000
ale swafford 111-11-1112 PS PLUS

The reason their are repetive SSNs, but different names are due to family
members will sign up for different products but they will be listed under
owners SSN, that is at the beginning of each repetitive SSN. I would like the
data to look like:

Amy burden 111-11-1111 LTD STD CHILD
kim swafford 111-11-1112 PS
1000 PS PLUS