I currently have:
Quarter | Q_Category | Q_Description | Value |
Q2 | pets | dogs | 0.123456 |
Q3 | pets | dogs | 0.123456 |
Q2 | pets | cats | 0.123456 |
Q3 | pets | cats | 0.123456 |
Q2 | family | mom | 0.123456 |
Q3 | family | mom | 0.123456 |
Q2 | family | dad | 0.123456 |
Q3 | family | dad | 0.123456 |
but need the data to look like this:
Q_Category | Q_Description | Q2 Value | Q3 Value |
pets | dogs | 0.123456 | 0.123456 |
pets | cats | 0.123456 | 0.123456 |
family | mom | 0.123456 | 0.123456 |
family | dad | 0.123456 | 0.123456 |
I am very new to Alteryx and am having a difficult time trying to move/separate these values. Any ideas would be great! Thanks!
Solved! Go to Solution.
Hey @HBarkdoll! First you can use a Formula tool to change the value in your Quarter column using:
[Quarter] + " Value"
From there, use a Cross Tab tool and group by Q_Category and Q_Description. Use Quarter as the new column headers and Value as your new column values. Hope this helps!
Thanks for your question!
The tool you are looking for is called the 'Cross Tab' tool. Here is a very helpful 'Tool Mastery' article for this tool. Additionally, I've attached a workflow which uses this tool to achieve your use case using your sample data.
Hope this helps!