How do i move like data in columns to single rows?

I have a spreadsheet that lists transactions numbers for ticket sold for our event. Each transaction number may have two or more entries and are in column form. I want to move the like data for each matching transaction number to the same (or one) row.

For example:
1060002 George Wallace Guest W67
1060002 Karen Cline Wallace W67


In this case, my name should really be above George's. But I want to also move my data to the same row.

1013137 Larry Parks W68
1013137 Diane Parks Guest W68


In other words, the graduate should always be listed before the guest.

I want it to look like this:

1013137 Larry Parks W68 1013137 Diane Parks Guest W68


If we can eliminate the second transaction # 103137, that would be great too.

Each year, we go through this and manually manipulate the data. it would be easier I we could automate it as we download new entries. I realize I will need to manipulate some of the data where one person paid for 6 with different names but I can work with that.

Appreciate any help to get me started. We are a high school reunion with 2 schools, classes of the 60s and ussally end up with at least 650 attendees.
Thanks,
Karen