Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
12 - Quasar

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