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.

 

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