Hello everyone! I am very new to Alteryx and am looking for some help to transform my data set.
I am working with a dataset that looks like this
City Name | New York | |||
Branch Name | Green | |||
Year | 2021 | |||
Category | Target 1 | Target 2 | Target 3 | |
A | 1 | 2 | 3 | |
B | 4 | 5 | 6 | |
C | 7 | 8 | 9 | |
D | 10 | 11 | 12 | |
E | 13 | 14 | 15 | |
F | 16 | 17 | 18 |
I want to take the information and create a new table where for each number I pull the Column Name, the category as well as the misc. information on the top left so that the resulting table looks sort of like this.
City Name | Branch Name | Year | Category | Target # | Amount |
New York | Green | 2021 | A | 1 | 1 |
New York | Green | 2021 | A | 2 | 2 |
New York | Green | 2021 | A | 3 | 3 |
New York | Green | 2021 | B | 1 | 4 |
New York | Green | 2021 | B | 2 | 5 |
New York | Green | 2021 | B | 3 | 6 |
New York | Green | 2021 | C | 1 | 7 |
New York | Green | 2021 | C | 2 | 8 |
New York | Green | 2021 | C | 3 | 9 |
Hi @Ralphlahens
Here's one way. Isolate the data and the header using sample tools. The header info needs to be cross-tabbed and appended to the dataset. Then the dataset just needs to be transposed to get the target #s how you need them.
Thank you so much, I'll try it out right now!
Thank you so much!