Moving Vertical Data into Horizontal Data

Hi Cmaskew,

The following macro assumes:
1. The SSN entries are all grouped together in consecutive rows.
2. You have headers in row 1 of Sheet2 for the new list to be created.
3. There are only three possible relation types (00, 01 and 02).

It even handles instances where there are more than two children (just keeps adding them in columns further to the right (leaving an empty column between entries).

Please Login or Register  to view this content.

I've attached the sample spreadsheet I used. You can open it and run the reorg macro. Hope that helps!