Specific row to column

[alexpereira]

Hi! I have the following table:

I would wanted transform/transpose the first row ("Amarela", "Negra") to column and the second row ("H", "M") to columns, but, of course, keeping the numerics values. The output table would be like:

Thanks for any help.

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here - Rearrange a multi heading dataset into a single heading one which is Pivot ready.

Hope this helps.

[alexpereira]

Hi, thanks for your reply, Mathur. But in fact I know the desired output. My question is how do it in Power BI.

[Ashish_Mathur]

Hi,

Please go through the steps in the Aplied steps section of the Query Editor there.