Help with Pivot Columns

[Anonymous]

Hi,

I'm trying to do a Pivot operation that seemed easy for me, but I can't make it work.

What I want is to turn the table on the Right into the table on the Left, but the Pivot operation does not work, since it will return a list instead of a sigle value.

Any ideas?

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

In Power Query, select both columns and unpivot the table.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel