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.

[OTrieger]

@LorenzTaylor 
You will need to Transpose the data and then to Cross Tab it

[CoG · Accepted solution]

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!

[OTrieger]

@CoG 
Indeed, the best way to keep the naming is replacing it with recordid and then rename it back, totally agree on that.