Cross Tab/Transpose tool

LorenzTaylor

Good Morning -

This may be a simple question. I'm currently trying to use the cross tab tool to rearrange how my columns are displayed. Currently, column [User ID] has the associated names in a vertical format. I would like the [User Id]'s to be displayed as the column names and the [activity] should replace where the [User id] names are listed. i would also like to create a new column totaling each activity. Please see example below.

Alteryx Example.xlsx

CoG

As @OTrieger mentioned the main functionality of this workflow involves Transpose and Cross Tab Tools. Unfortunately, the Cross Tab Tool renames your fields. Here is still simple (but less so) workflow that accomplishes your needs, but does so in a way that preserves desired column names. (Note: I added a "Total" column in the Cross Tab Tool, you can remove it if it does not need to be in the final output):

Hope this helps and Happy Solving!

Sample Workflow.yxmd