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?
2016 | 2017 | ||
Tesco | Items Sold | 45 | 30 |
Tesco | Items Bought | 50 | 51 |
Sainsburys | Items Sold | 32 | 34 |
Sainsburys | Items Bought | 51 | 34 |
Asda | Items Sold | 100 | 102 |
Asda | Items Bought | 105 | 102 |
Solved! Go to Solution.
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
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |