Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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