Forum Discussion
Transpose & Pivot Order Problem
Hello, meikastler try the following steps (from the table on the screenshot)
- promote headers
- unpivot all columns except first 2 (Type and Month)
- pivot Type column
Then you'll need to split prod description column (created by unpivot step) to get OEM/Make/Model/SKU or whatever in separate columns as well as reorder forecast/actual columns either manually or M code. Is this the way you are looking for?
Super UserHello, meikastler try the following steps (from the table on the screenshot)
- promote headers
- unpivot all columns except first 2 (Type and Month)
- pivot Type column
Then you'll need to split prod description column (created by unpivot step) to get OEM/Make/Model/SKU or whatever in separate columns as well as reorder forecast/actual columns either manually or M code. Is this the way you are looking for?
AlienSx, THANK YOU!
I knew there had to be an easy way to do this and I was just too inexperienced to find the right combo in my early stages. This was an AMAZING learning experience and now I can do it to the bigger table!!
Once again, thank you so, so much! 😍
