Forum Discussion

pakovic's avatar
pakovic
Helper I
3 years ago
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...
  • HotChilli's avatar
    3 years ago

    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)