Hi, I have my input like below example. May I know how can I transpose the data from columns to rows?
Input Data:
Pilot_Yr10 | Vermont_Yr10 | Pilot_Yr9 | Vermont_Yr9 | Pilot_Yr8 | Vermont_Yr8 |
2014 | 2014 | 2015 | 2015 | 2016 | 2016 |
9.67 | 9.67 | -3.76 | -3.76 | 18.4 | 18.4 |
9.02 | 9.02 | -4.33 | -4.33 | 17.7 | 17.7 |
13.69 | 13.69 | 1.41 | 1.41 | 11.96 | 11.96 |
Expected Output Data:
Period | Pilot | Vermont |
SI | Since Inception 1/1/91 | Since Inception 1/1/91 |
Yr1 | 2023 | 2023 |
Yr10 | 2014 | 2014 |
Yr2 | 2022 | 2022 |
Yr3 | 2021 | 2021 |
Yr4 | 2020 | 2020 |
Yr5 | 2019 | 2019 |
Yr6 | 2018 | 2018 |
Yr7 | 2017 | 2017 |
Yr8 | 2016 | 2016 |
Yr9 | 2015 | 2015 |
Best answer by Pele
View original