Column Value To Column Header?

[Christoph1972]

Hello,

I have the following table:

ID, CODE, VALUE

44, AAA, 1
44, BBB, 1
44, CCC, 1
44, DDD, 1
45, AAA, 2
45, BBB, 2

I’d like to have the following output:

ID, AAA, BBB, CCC, DDD

44,   1       1,       1,       1
45,   2       2

Is there a way to do this in Power BI?

[johnt75 · Accepted solution]

In Power Query select the Code column then from the Transform section of the ribbon choose Pivot Column and choose the VALUE column to provide the values.

[Christoph1972]

Perfect, thanks a lot!  🙂