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
Solved! Go to Solution.
Thank you so much! This was my first time posting and I got such a complete solution and sooo fast! ;)