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

13 Replies

  • ahadkarimi's avatar
    ahadkarimi
    Solution 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
      Helper 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
        Solution 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Antoinette123 ，

     

    Is your problem solved? If not, can you provide me with some of what it looks like in your Power Query?

    It would be nice to have a more detailed description of the problem, thank you.

    When you provide screenshots, please protect your privacy.

     

    Best Regards,

    Stephen Tao