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
