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"
Hi meikastler ,
that doesn't look to me like so.
In row 11 we have the 2nd jan and the column left to it shows "Forecast".
OMG! I did a Replace Values and the extra Jan is supposed to be November and the extra Feb is supposed to be December. I apologize! I took the photo before I fixed that particular error 😣
