Hi. I have the below data and need to change the first 3 rows to columns, so that each metric will have the year, month, sales, and forecast. How can I make this possible?
2021 | 2021 | 2021 | 2021 | 2021 | |
Sales | Sales | Forecast | Forecast | Forecast | |
Sep | Oct | Nov | Dec | Total Yr | |
Metric 1 | 10 | 20 | 15 | 10 | 1200 |
Metric 2 | 40 | 80 | 15 | 35 | 1300 |
Metric 3 | 70 | 40 | 15 | 60 | 3400 |
Metric 4 | 50 | 80 | 15 | 85 | 4167 |
Metric 5 | 19 | 26 | 15 | 110 | 5267 |
Can you show us your desired output?