Hello Everyone,
I have run into an issue with transforming input data, where I need to transform input data per the screenshot attached - essentially so that there is a separate row input for each customer for each month.
Main trouble is that Alteryx struggles to recognise the multi row categories and therefore transform it and so on.
| CURRENT DATA FORMAT: | | | | | | | | | | |
| | | | | | | | | | | |
| | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 |
| | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 |
| Category | Qty | Sales | COGS | Gross Profit | GP% | Qty | Sales | COGS | Gross Profit | GP% |
| Company A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Company B | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| | | | | | | | | | | |
| DESIRED OUTPUT DATA FORMAT: | | | | | | | | | | |
| | Company | Qty | Sales | COGS | Gross Profit | GP% | | | | |
| 2020-7 | Company A | 1 | 2 | 3 | 4 | 5 | | | | |
| 2020-7 | Company B | 11 | 12 | 13 | 14 | 15 | | | | |
| 2020-8 | Company A | 6 | 7 | 8 | 9 | 10 | | | | |
| 2020-8 | Company B | 16 | 17 | 18 | 19 | 20 | | | | |
Can somebody help with this ASAP?
Thanks!!
