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