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 |
| | | | | | |
| | | | | | |
