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
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?

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