ExcelOnTheClock
New Member
- Joined
- Dec 1, 2022
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
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!
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!