Tranpose without aggravating values

[samxhander09]

Hi! I'm looking to transfrom my data from this:

To this:

I tried to use transpose tool but it aggravates the values.

[AndrewDMerrill · Accepted solution]

Here is a sample workflow that does what you desire. The issue is that Alteryx via the Cross Tab Tool has no way of knowing that you want three columns that all have the exact same name vs. one column that gets aggregated. As a matter of principle the default makes sense because it is not generally good practice to have a table with multiple columns that have the same name (although for formatting it does make sense that the output should look however you need it to). We solve this problem by forcing unique column names:

[samxhander09]

Thank you for your help!