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.
fireworks

Transpose multiple columns into rows

Krakan
6 - Meteoroid

Hello,

 

I am trying to transpose multiple columns into rows.

 

Here is my data:

 

Krakan_1-1666275051682.png

 

I want the result to be :

 

Krakan_0-1666275291244.png

 

 

Thank you so much for your help.

 

 

7 REPLIES 7
Emmanuel_G
13 - Pulsar

@Krakan 

 

Find in attachement a solution  to this issue.

 

Let me know if there is an issue with this solution.

 

Emmanuel_G_0-1666278586671.png

 

Emmanuel_G
13 - Pulsar

@Krakan It worked ?

Krakan
6 - Meteoroid

It works, thanks a lot!

Krakan
6 - Meteoroid

Hi,

 

Unfortunately it doesn't work beacuse the final result in your workflow is:

 

Krakan_0-1666358547224.png

I need below result:

 

Krakan_1-1666358599447.png

Do you know how can I change it?

Thank you.

Krakan
6 - Meteoroid

@Emmanuel_G 

Could you please take a look for my reply?
Thank you.

Emmanuel_G
13 - Pulsar

Hi @Krakan 

 

All my excuses for this mistake ! 

 

You can find in attachement the version of workflow which generate correct output.

 

Let me know if there is still any issue.

 

Emmanuel_G_0-1666653307167.png

 

Krakan
6 - Meteoroid

Hi @Emmanuel_G 
Unfortunately this solution cannot be adjusted to my dataset because in my original dataset I have more columns/rows.

Sorry for the confusion I just wanted to know universal method.

 

Please find my original dataset (more columns than rows and net new money/loans instead measure1/measure2).

 

Krakan_0-1666681170565.png

Below desired output.

 

Krakan_1-1666683233432.png

Thanks in advance.

Labels
Top Solution Authors