Could you please help me to get the desired result in Alteryx I am not sure whether I should use transpose tool or crosstab tool. Please see the attached pic
Thanks.
Solved! Go to Solution.
here is an answer for you. you'll note that the columns in my answer are in a different order than the way that you created your desired output. if it is necessary to have them in that specific order, then you'll need to calculate column orders and apply them with logic.
Cheers,
Mark
This is perfect, Thanks Mark.