We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transpose multiple columns into rows

Krakan
6 - Meteoroid

Hello,

 

I am trying to transpose multiple columns into rows.

 

This is my data:

 

Krakan_2-1666360329274.png

 

I want the result to be :

 

Krakan_3-1666360388542.png

 

Thank you so much for your help.

4 REPLIES 4
Krakan
6 - Meteoroid

Hi @Luke_C 
Unfortunately I have different example. I have tried to adjust that solution to my workflow but it doesn't work.

Could you please help me on this matter?

Thank you.

Luke_C
17 - Castor
17 - Castor

Hi @Krakan 

 

Can you attach the data (not screenshots that people will need to re-type) and the workflow you've tried? 

Krakan
6 - Meteoroid

Hi  @Luke_C 
Please find attached my workflow.
My input:

Krakan_0-1666680898991.png

 

My desired output:

Krakan_0-1666683288221.png

 

 

 

I have created part of the final table, but I don't know how to build the rest of flow.
I would like to ask you for assistance.

Thanks in advance.

Labels
Top Solution Authors