Transpose

[pakovic]

Is it possible to transpose the table in this way?

I have tried with Transpose and undo dynamization of powerbi columns but I have not been able to do it.

the result should look like this

columna1	ph	grado	temperatura
1	10	5
2	10	8
3	10	41	23

here is the pbix

https://www.dropbox.com/s/mzqzwokd0mvxiuw/transpose.pbix?dl=0

thank you in advance for your help

[HotChilli · Accepted solution]

You can Pivot (from the Transform menu in Power Query) Column2 using Column3 in Values.

With the data provided - 'Don't Aggregate' should work (from the Advanced options)

[pakovic]

¡¡thank you very much HotChilli!!