Change column for heather

[Anonymous]

Hi, 

I must change a column for new heathers... Ihave this: 

And I need this: 

It must be as a table not as a matrix, because I'll do a Pareto after that in the same table

Regards

[v-shex-msft · Accepted solution]

HI @Anonymous,

You can enter to query editor side and duplicate the raw query table as backup, then you can use pivot column feature to transform the table rows to columns.

Pivot columns - Power Query | Microsoft Learn

If you are confused about coding formula and detail operation steps, please share some dummy data and paste here with table format then we can simply copy these to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng