Split data into rows

[Shaaz]

I've a data like below where Country is the column name.

I would like to see the data as below.

[Luke_C · Accepted solution]

Hi @Shaaz 

You can use the text to column tool, which has a split to rows option - see below screenshots & attached workflow. I used a record ID to join the original records back for your desired presentation.