Combine row data based on Duplicate ID

[mlgill]

ID-SSN City Pet1 Pet2 Pet3 Pet4
111-11-1111 Baltimore Dog Bird
111-11-1111 Cow
777-77-7777 Augusta Cat Horse
777-77-7777 Dog
777-77-7777 Cow

I am trying to MASH UP rows with duplicate ID-SSNs.
End result would be:

ID-SSN City Pet1 Pet2 Pet3 Pet4
111-11-1111 Baltimore Dog Cow Bird
777-77-7777 Augusta Cat Dog Horse Cow

Any advise. I'm really stuck. Tried some nested IF statements to no avail.
Any help is GREATLY APPRICIATED! Michelle

The sample above didn't post visually as I had hoped. The "cow" entry for 2nd line of 111-11-111 should show as being located in the Pet3 column.
For row 4 777-77-7777 Dog is located in Pet2 and row 5 777-77-777 Cow is located in Pet4. Hope I haven't confused you further..ugh.