Forum Discussion
Antoinette123
Helper I
Helper ISeparating 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"?
ahadkarimi
Solution Specialist
Solution SpecialistHey 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.
Antoinette123I've tried that, it doesn't do what I need, unfortunately. Cause the whole Plan/Fact column has only 2 possible values: either "Plan" or "Fact", not 2 values to separate them by delimiters
- ahadkarimi
Antoinette123 try this way and let me know if there is any issue:
Select "Plan-Fact" and any key columns.
Go to Transform → Pivot Column.
Pivot "Plan-Fact", choose your values column, set to "Don’t Aggregate".
Hit Close & Load.- Antoinette123
No, also not that. I got something strange 🙂