Hello all, I'm new at Alteryx and thus, not know much on how to use it.
I am trying to transpose some data from columns to row, but what I've found in the description of the tool 'transpose' doesn't seem to work for what I want. Can anybody help me / guide me with this?
What I want to do is the following. The data from Table 1/Origin is, as example:
| NAME | 01/01/2019 | 02/01/2019 |
| A | 1 | 2 |
| B | 3 | 4 |
| C | 5 | 6 |
| D | 7 | 8 |
And I want to end with the data like this:
| NAME | DATE | DATA |
| A | 01/01/2019 | 1 |
| B | 01/01/2019 | 3 |
| C | 01/01/2019 | 5 |
| D | 01/01/2019 | 7 |
| A | 02/01/2019 | 2 |
| B | 02/01/2019 | 4 |
| C | 02/01/2019 | 6 |
| D | 02/01/2019 | 8 |
How can I do this? Is it possible?
