Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Create a category column based on column names

I'm working on a data file that has details of different types of deductions for example pension contributions, taxes etc. Each of this deductions is a column in the data file with their respective v...
Need Help
  • suparnababu8's avatar
    suparnababu8
    1 year ago

    Hi Anonymous 

    I think you will achieve by using unpivot option in Power Query editor.

    If you see dummy data as mentioned below..

    Then you need to perform Unpivot action by selecting columns. Now you'll get output as mentioned below.

     

    Is this you are expecting?

suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

I think you will achieve by using unpivot option in Power Query editor.

If you see dummy data as mentioned below..

Then you need to perform Unpivot action by selecting columns. Now you'll get output as mentioned below.

 

Is this you are expecting?