Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Stuck on Cross tab / transpose

chickenlicken
8 - Asteroid

Hey there,

I am stuck on what I feel is a simple problem but I cannot resolve!  I have data structured as the first table below.  I would like to transform it so that the Year becomes column header rather than row value - as per the second table below.  

 

how do I do this?

 

crosstab.JPG

  20162017
TescoItems Sold4530
TescoItems Bought5051
SainsburysItems Sold3234
SainsburysItems Bought5134
AsdaItems Sold100102
AsdaItems Bought105102
2 REPLIES 2
chickenlicken
8 - Asteroid

I think I may have figured it out using this similar problem

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-transpose-table/td-p/21430

chickenlicken
8 - Asteroid
 
Labels