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.

Antoinette123's avatar
Antoinette123
Icon for Helper I rankHelper I
2 years ago

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

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

      No, also not that. I got something strange 🙂

      • ahadkarimi's avatar
        ahadkarimi
        Icon for Solution Specialist rankSolution Specialist
        2 years ago

        Antoinette123 Could you explain it in more detail, or provide a better example, or if possible, provide and share a part of the sample file so that I can help better?