Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Convert data to better shape

Qusaiamer
7 - Meteor

Hi all!

 

I just started working with Alteryx so here is your newbie question of the day:

 

How can I make the id values headers i.e the first column will have all the names, the second all the departments, etc. I have been trying to use transpose/corss tab but I still don't fully get how they work. Any help will be greatly appreciated.

 

Thanks!

2 REPLIES 2
gabrielvilella
14 - Magnetar

Hi @Qusaiamer, maybe something like this. Of course you could create a macro for this so you don't need to keep repeating the same steps. Maybe someone else has a better idea.

gabrielvilella_0-1643143622209.png

 

binuacs
20 - Arcturus
Labels