Pivot table from columns to rows - changing FX table to do lookup

[Anonymous]

In Power Query I have a table that looks like the below but I want to pivot it so that the column headers become rows which will need to then repeat.

How can I take my existing table and pivot the header row so they become individual rows like illustrated below?

[AlB · Accepted solution]

Hi @Anonymous 

Just select USD and CAD columns and choose "Unpivot Columns"

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers