Forum Discussion
Solved
Unstacking Forecast and Actual Data from a Single Column
I am brand new to Power Query and have been stuck on this problem for the past 5 days. I've tried watching tons of YouTube videos (especially by Goodly), but the solutions provided don't help my spec...
No worries 🙂
OK, so if the values in column2 are unique for each value in column1, then a pivot-operation would do the job:
1) Check Column1
2) go to Transform tab and choose "pivot column"
3) Select Column3 for the "Values Column"
No worries 🙂
OK, so if the values in column2 are unique for each value in column1, then a pivot-operation would do the job:
1) Check Column1
2) go to Transform tab and choose "pivot column"
3) Select Column3 for the "Values Column"
IT WORKED!!! OMG THANK YOU!!!
As a last question, how do I get the pivoted months to be in order?
