Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
21 - Polaris
Labels
Top Solution Authors