Forum Discussion
Solved
Group Column Headings
Hi I have a data set that contains multiple columns each with a specific role type, for each line i then have a different supplier and the rates that they offer for that role type. PM Ad...
Hi StuMills ,
The way to do this is to go to PowerQuery. Select the first 2 columns (Supplier and PM) and use Unpivot other columns. This will give you the result below:
Then you can use it as a filter:
Jori
If I answered your question, please mark it as a solution to help other members find it more quickly.
jppv20
Solution Sage
Solution SageHi StuMills ,
The way to do this is to go to PowerQuery. Select the first 2 columns (Supplier and PM) and use Unpivot other columns. This will give you the result below:
Then you can use it as a filter:
Jori
If I answered your question, please mark it as a solution to help other members find it more quickly.