Convert data to better shape

Question

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!

fghfgh.PNG

binu_acs · Answer

@Qusaiamer You can find a similar weekly challenge in https://community.alteryx.com/t5/Weekly-Challenge/Challenge-112-Organizing-Survey-Data/td-p/154577

SurveyData1.yxmd

gabrielvilella · Answer

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.

Data Transformation.yxmd