Hi,
I have a data set where I need to move columns to rows. What is the easiest way to do this please? Thank you!
Example data:
Original:
ID Country
1234 China
1234 China
1234 Portugal
1234 Spain
1001 Portugal
1002 France
1002 Germany
Format needed:
ID Country Country2 Country3
1234 China Portugal Spain
1001 Portugal
1002 France Germany
Solved! Go to Solution.