Forum Discussion
Solved
Specific row to column
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.
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.
3 Replies
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.
Hi, thanks for your reply, Mathur. But in fact I know the desired output. My question is how do it in Power BI.
Hi,
Please go through the steps in the Aplied steps section of the Query Editor there.
