Hello - I'm attempting to split one row into multiple based on the number of years. Example below:
This is the source data. The dates are for every month in 2022, 2023, and 2024 but I've condensed it keep it simple.
Below is what I hope to achieve:
I'd prefer to use index match formula somehow but am having a hard time getting it to work. Any help would be much appreciated
This is the source data. The dates are for every month in 2022, 2023, and 2024 but I've condensed it keep it simple.
ID | Account | 1/31/2022 | 2/28/2022 | 1/31/2023 | 2/28/2023 | 1/31/2024 | 2/28/2024 | |
1234 | 1111 | 100 | 100 | 200 | 200 | 300 | 300 | |
1235 | 2222 | 95 | 95 | 105 | 105 | 115 | 115 |
Below is what I hope to achieve:
ID | Account | Year | Jan | Feb |
1234 | 1111 | 2022 | 100 | 100 |
1234 | 1111 | 2023 | 200 | 200 |
1234 | 1111 | 2024 | 300 | 300 |
1235 | 2222 | 2022 | 95 | 95 |
1235 | 2222 | 2023 | 105 | 105 |
1235 | 2222 | 2024 | 115 | 115 |
I'd prefer to use index match formula somehow but am having a hard time getting it to work. Any help would be much appreciated
Last edited by a moderator: