Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Transpose 2 Columns to 2 Rows

YeahMan
8 - Asteroid

Hi community,

 

I have what seems to be a simple problem but haven't found a simple solution. I want to take 2 columns of data and turn it into 2 rows of data.

 

Make this:

Columns.JPG

 

Look like this:

 

Rows.JPG

I will be using the Dynamic Rename tool afterwards to make the 2nd row become my header row, but I need the 1st row in order to union the header and data back together. There are 255 columns.

 

Any help would be appreciated.

Thanks,

--sue

2 REPLIES 2
phottovy
13 - Pulsar
13 - Pulsar

The Cross Tab tool is what you are looking for. Don't select any columns to group by and use "Name" for the headers and "Value" for the values. 

YeahMan
8 - Asteroid

OMG I tried what I thought was every variation of the Cross Tab tool except this one! THANK YOU!!

Labels