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

Transpose a table to columns

FabioP
8 - Asteroid

Dearl all,

 

I have this table below:

FabioP_0-1594646482785.png

 

I'd like to transform into this:

FabioP_1-1594646574698.png

 

My difficulty is with the header with 3 lines...

Could someone help me? I almost got there!

 

Follow the excel file.

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @FabioP 

 

Here's a way of doing it.

 

Thableaus_0-1594647919155.png

 

 

WF attached. Replace your input file with your file path.


Cheers,

LordNeilLord
15 - Aurora

Hey @FabioP 

 

I'd do something like this:

 

Capture.JPG

Labels
Top Solution Authors