I am bringing in data from a sheet in excel and I need to reformat it into better columns and rows in Alteryx as part of a larger workflow. I think it would be considered unpivoting columns, but I'm not familiar with how to do this in Alteryx.
I have data that looks like this:
| | Forecasted year | 2021 | 2021 | 2021 |
| | Forecasted month | September | October | November |
| | | | | |
| Loc Name | Prod mix | Cost | Cost | Cost |
| Loc A | Average | 100 | 200 | 300 |
| Loc A | 10 | 101 | 201 | 301 |
| Loc A | 16 | 102 | 202 | 302 |
| Loc B | Average | 103 | 203 | 303 |
| Loc B | 7 | 104 | 204 | 304 |
| Loc B | 12 | 105 | 205 | 305 |
But I want it to look like this:
| Loc Name | Prod mix | Forecasted Year | Forecasted Month | Cost |
| Loc A | Average | 2021 | September | 100 |
| Loc A | Average | 2021 | October | 200 |
| Loc A | Average | 2021 | November | 300 |
| Loc A | 10 | 2021 | September | 101 |
| Loc A | 10 | 2021 | October | 201 |
| Loc A | 10 | 2021 | November | 301 |
| Loc A | 16 | 2021 | September | 102 |
| Loc A | 16 | 2021 | October | 202 |
| Loc A | 16 | 2021 | November | 302 |
I'm not sure how to get the date fields into the rows. I feel like this shouldn't be too difficult, but I am completely baffled! I've attached the sample input data. Thanks for the help!
