Text to Columns tool on a condition

[crogers]

I need to combine the rows that have the same ID number into one row.  If the Primary Location =Y  then the Location ID needs to go to a new column entitled "Primary Location ID" and all other Primary Locations that = N need to go into Alternate Location # .  How can I do this with the Text to Columns based on a conditional value?  How do I do this?

Name      ID         Status          Location ID     Primary Location?     

John        20       Active               10200                Y

Dave       68       Active               32987                Y

Dave       68       Active               32991                N

Dave       68       Active               34031                N

Results need to be:

Name      ID      Status            Primary Location ID         Alt Location 1        Alt Location 2     Alt Location 3

John        20      Active                     10200

Dave       68      Active                      32987                             32991                34031

[LordNeilLord · Accepted solution]

How about something like this?

[crogers]

Thank you so much! This was my first time posting and I got such a complete solution and sooo fast!   ;)