Forum Discussion

Antoinette123's avatar
Antoinette123
Icon for Helper I rankHelper 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
ahadkarimi's avatar
ahadkarimi
Icon for Solution Specialist rankSolution Specialist
2 years ago

Hey Antoinette123, try and let me know if there is any problem.

Load Data into Power Query.
Select "Plan-Fact" Column.
Transform → Split Column → By Delimiter (choose appropriate delimiter).
Rename Columns to "Plan" and "Fact".
Close & Load.