I have a very large data set that I need to format per the attached spreadsheet.
Essentially, I have data for individual people that own a varying number of unique accounts. Think of Customer A having 25 unique accounts and Customer B having 4 unique accounts, etc. The data set is around 12,000 individuals long and with varying number of accounts. The data is currently in grouped in a single row, but I'd like to transpose this into columns for each individual (i.e. customer A in cell A1, Account 1 in Cell B1, Account 2 in Cell B 2, etc....)
Original:
Name Account 1 Account 2 Account 3 Account 4 Account 5
Jon 604 60 707 831 762
Ryan 250
Mary 129 524 769
Bob 53 566 722 619
Desired:
Name Account #'s
Jon 604
560
707
831
762
Ryan 250
Mary 129
524
769
Bob 53
566
722
619
Bookmarks