PowerQuery question: how to make my 2nd column become my top row (or even the header row)?

[ExcelOnTheClock]

Hello, I'm new to PowerQuery and loving it so far. I have some ETF prices I pulled from Yahoo Finance and pulled into PowerQuery. I have manipulated it into the following (Table 1):


I want the data to look like the following (Table 2). Essentially, I want the "Ticker" column to instead by Header Row, if possible.


I thought a good way to do this would be to Unpivot the Ticker column, or perhaps the other 2 columns. However, when I do that, I under up with something like Table 3:


I guess I really don't understand Unpivot very well. How can I make data look like Table 2? Thanks in advance!

 

[Automatrix]

Choose the Ticker column, then Pivot Column, with Price as the Values Column. unPivot is for going the other way.

 

[ExcelOnTheClock]

Choose the Ticker column, then Pivot Column, with Price as the Values Column. unPivot is for going the other way.

View attachment 80010

Thank you! Easier than I expected

 

[Automatrix]

Thank you! Easier than I expected

You're welcome. "Easier than I expected" should be the official Power Query motto. Please mark the post as the solution to help the search engine.

 

[ExcelOnTheClock]

Done!