Forum Discussion

Antoinette123's avatar
Antoinette123
Helper I
2 years ago

Separating columns in Power Query

Hi! There is a pivot table. How to separate the column "Plan-Fact" (that has options -kinda filters 'Plan', 'Fact' inside of it) into 2 separate columns named "Plan" and "Fact"?  
Need Help
Antoinette123's avatar
Antoinette123
Helper I
2 years ago

I selected "Plan-Fact" and Month columns. Went to Transform → Pivot Column. Pivot "Plan-Fact", set to "Don’t Aggregate". And in the final table there was only 1 column, not 2 separate "plan" and "fact" columns

ahadkarimi's avatar
ahadkarimi
Solution Specialist
2 years ago

Antoinette123c, can you send another photo like the one below and explain a bit more clearly?