Alteryx Designer Desktop Discussions

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

Transposing my summarize output

RogerA
8 - Asteroid

Hello, i am trying to transpose output from a summarize to present it better.  I've been playing with the crosstab, transpose and arrange tools, but cannot get the desired effect.  My data looks like:

 

Record#   Column1   Column2   Column3

1               84              1783         2884

 

What i want to get it looking like is:

 

Column1     84

Column2     1783

Column3     2884

 

I only have one row of data as it's from a summarize, so the examples on the forum i'm reading are all different.

2 REPLIES 2
patrick_digan
17 - Castor
17 - Castor

I think the transpose tool with Columns 1-3 selected as Data fields should work. Let me know if your actual dataset is more complicated.

 

Capture.PNG

RogerA
8 - Asteroid

Worked perfectly, thanks!

Labels