I am trying to figure out the easiest way of transposing data from horizontal to vertical (and the other way around).
E.g.
Data 1:
| Name | A | B | C | D |
| Value | 12 | 78 | 78 | 90 |
| Total | 1 | 8 | 7 | 5 |
Data 2:
| Name | Value | Total |
| A | 12 | 1 |
| B | 78 | 8 |
| C | 78 | 7 |
| D | 90 | 5 |
I have been struggling to get Data 1 into the shape of Data 2 and the other way around. I don't know what I am doing wrong with transpose/cross tab, but it seems like it always takes multiple tools to get it into the right shape.
My personal "work around" is going back to Python and using the Pandas Transpose method. I've converted my Python-1-liner into a macro to reuse it everytime I stumple accross this issue.
It's just one line in Python*, 2-3 Clicks in Excel and I wonder why I struggle so much in Alteryx. Alteryx makes many complex stuff easy, but it's sometimes hard to do the easy things. I hope someone can tell me how to convert the data from 1->2 / 2 ->1 with just one tool.
*Python Code: Alteryx.write(Alteryx.read('#1').T, 1)
