In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Split data into rows

Shaaz
9 - Comet

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

 

Shabaz_0-1640010069270.png

 

 

 

I would like to see the data as below.

Shabaz_0-1640009810110.png

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

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. 

 

 

Luke_C_0-1640010278796.png

Luke_C_1-1640010298802.png

 

Labels
Top Solution Authors