Hi All,
I currently have a data set that looks like this:
Group | Column A | Column B | Column C |
A | Blue | Black | Red |
A | Green | Black | Red |
B | Green | Black | Red |
B | Yellow | Blue | Red |
B | Red | Black | Red |
C | Yellow | Blue | Red |
C | Yellow | Blue | Black |
Is it possible to group this table using the column 'Group' and have each 'Group' appear next to each other (side-by-side) rather than one after another? Like below:
A | A | A | B | B | B | C | C | C |
Column A | Column B | Column C | Column A | Column B | Column C | Column A | Column B | Column C |
Blue | Black | Red | Green | Black | Red | Yellow | Blue | Red |
Green | Black | Red | Yellow | Blue | Red | Yellow | Blue | Black |
Solved! Go to Solution.
Might try something like the attached workflow, which leverages Transpose and Cross Tab to pivot your data as needed... keep in mind, however, that Alteryx will only give you an option for one row of headers, so in the solution provided, I have shown "Group_A_Column_A", "Group_A_Column_B", etc. as your header row, which combines the Group & Column names rather than having them stacked on top of each other.
Hopefully this gets you pointed in the right direction! :)
Cheers,
NJ
Hi @E123
This is definitely possible. You will have to do a bit of investigating with the Cross Tab and Transpose tools. I am unfortunately not at my main computer at the moment (as I am about to leave on holiday) otherwise could give it a bash.
Let me know how you get on.
Thanks