Pivot troubles

[Jeff_Murfin]

Hi All, unsure why I am stuck on this. Need to take user IDs with multiple attributes and pivot them as follows:

Original Data:

Desired Data Set:

xlsx of both are attached...

Trying to use the Cross Tab tool with no luck. Any suggestions, please? 

Thanks,

Jeff

[JosephSerpis]

Hi @Jeff_Murfin you need to use the transpose tool instead.

[JosephSerpis · Accepted solution]

I amended the workflow to get the order to match your output. I had to use a combination of a Record ID tool and Multi Row in order to sort corretly.

[Jeff_Murfin]

Thank you very much Joe! I really appreciate you taking the time to help me figure this out. I'm relatively new to Alteryx, so I'm not well-versed in all the tools yet,