Forum Discussion
Solved
Transpose
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
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)
