Group columns by Row so they appear side by side (rather than on top of each other)

Question

Hi All,

I currently have a data set that looks like this:

GroupColumn AColumn BColumn CA

BlueBlack RedA

GreenBlackRedBGreenBlackRedBYellowBlueRedBRedBlackRedCYellowBlue RedCYellowBlue 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:

AAABBBCCCColumn AColumn BColumn CColumn AColumn BColumn CColumn AColumn  BColumn CBlueBlackRedGreen BlackRedYellowBlue RedGreenBlackRedYellow BlueRedYellowBlue Black

NicoleJohnson · Accepted Answer

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