Moving data from rows to columns

[HannahSwain7]

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 

[aatalai]

@HannahSwain7 try this flow

let me know if it helps

[Cremo · Accepted solution]

Hi, 

you can try the attached WF. The number of columns in output is unknown so I am using a high number of columns to split (10) and then remove the null ones. You can increase that number in the "Text To Columns" tool if you need