How to combine data and delete rows

[PARSguy]

I have a spreadsheet with thousands of census data entries and I need to
combine multiple entries based on a social securtity number. An example
is below. I need to combine the contribution colum and the rest of the
info can remain the same while deleting the duplicate entry. Some
people may have more than 2 entries. Can anybody help with a macro
program. Thanks.

Ss# Name contribution Comp Birth date Hire
date
55555555 Doe, John 38.10 508.00 01/01/45 11/01/98
55555555 Doe, John 35.00 508.00 01/01/45 11/01/98
66666666 doe, Jane 22.50 300.00 03/01/60 02/15/06

 

[Jim Thomlinson]

Why not create a pivot table from this data in order to sum the
contributions... that is a whole pile easier and more flexible than code...