Alteryx Designer Desktop Discussions

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

Transpose

anitamarie2020
8 - Asteroid

Hi All, 

 

I was just wondering if you could advise what is the best way to transpose the below input to the below output, D

Depending on the Staff Name. 

 

anitamarie2020_0-1673888865846.png

 

3 REPLIES 3
FinnCharlton
13 - Pulsar

Hi @anitamarie2020 , 

This will work for you, although you can't have duplicate header names in Alteryx.

FinnCharlton_0-1673889893731.png

 

 

binuacs
20 - Arcturus

@anitamarie2020 One way of doing this

 

binuacs_1-1673902913082.png

 

 

 

anitamarie2020
8 - Asteroid

Thank you so much both - that was a huge help!

Labels