Transpose in alteryx

[larry1]

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.

[MarqueeCrew · Accepted solution]

@larry1,

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

[larry1]

This is perfect, Thanks Mark.