In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to transpose multiple columns into one?

bryanmac_92
8 - Asteroid

Hi,

 

I am trying to see how to multiple columns into one where this data:



InqTransferApps
300
323
100
100
222
212
110
101
720
181417

 

turns into

 

MetricValue
Inq3
Inq3
Inq1
Inq1
Inq2
Inq2
Inq1
Inq1
Inq7
Inq18
Transfer0
Transfer2
Transfer0
Transfer0
Transfer2
Transfer1
Transfer1
Transfer0
Transfer2
Transfer14
Apps0
Apps3
Apps0
Apps0
Apps2
Apps2
Apps0
Apps1
Apps0
Apps17
1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@bryanmac_92 
A Transpose tool does the exact you need here. 
I have added a small technique to get the data order as in your sample output.

0123-bryanmac_92.png

Labels
Top Solution Authors