Pivot troubles

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

Workflow

Datasets

Best Practices

Preparation

Accepted answers

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.

Transpose_Tool_13072021.yxmd

All comments

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

Transpose_Tool_13072021.yxmd

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.

Transpose_Tool_13072021.yxmd

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,

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703