I want to transpose the below input format into expected output as below. Please suggest.
Input
Month Year | PLAT | PY | FY24 | B |
---|
Oct-2022 | F | 1.00 | 2.00 | 3.00 |
Nov-2022 | F | 1.00 | 2.00 | 3.00 |
Dec-2022 | F | 1.00 | 2.00 | 3.00 |
Jan-2023 | F | 1.00 | 2.00 | 3.00 |
Feb-2023 | F | 1.00 | 2.00 | 3.00 |
Mar-2023 | F | 1.00 | 2.00 | 3.00 |
Apr-2023 | F | 1.00 | 2.00 | 3.00 |
May-2023 | F | 1.00 | 2.00 | 3.00 |
Jun-2023 | F | 1.00 | 2.00 | 3.00 |
Jul-2023 | F | 1.00 | 2.00 | 3.00 |
Aug-2023 | F | 1.00 | 2.00 | 3.00 |
Sep-2023 | F | 1.00 | 2.00 | 3.00 |
| | | | |
Output
PLAT | Month Year | Oct-2022 | Nov-2022 | Dec-2022 | Jan-2023 | Feb-2023 | Mar-2023 | Apr-2023 | May-2023 | Jun-2023 | Jul-2023 | Aug-2023 | Sep-2023 |
---|
F | PY | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
F | FY24 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 |
F | B | 3.00 | 3.00 | 3.00 | 3.00 | 3.00 | 3.00 | 3.00 | 3.00 | 3.00 | 3.00 | 3.00 | 3.00 |
| | | | | | | | | | | | | |