I am looking to pull the start and end dates of various data series across a single row. The data appears as follows:
The table here only allows for 10 columns, but the data stretches across 10 years, and the series of A, B and C data each can be any duration, 1, month, 2 months, a year, anything. They can be in any sequence, and there can be multiple series A, B and C across the row.
What I would like to do is pull the date ranges of the various series as follows:
Start, End, Series:
4/2/2024, 4/3/2024, A
4/5/2024, 4/7/2024, C
4/9/2024, 4/10/2024, B
How do I achieve that?
4/1/2024 | 4/2/2024 | 4/3/2024 | 4/4/2024 | 4/5/2024 | 4/6/2024 | 4/7/2024 | 4/8/2024 | 4/9/2024 | 4/10/2024 |
A | A | C | C | C | B | B |
The table here only allows for 10 columns, but the data stretches across 10 years, and the series of A, B and C data each can be any duration, 1, month, 2 months, a year, anything. They can be in any sequence, and there can be multiple series A, B and C across the row.
What I would like to do is pull the date ranges of the various series as follows:
Start, End, Series:
4/2/2024, 4/3/2024, A
4/5/2024, 4/7/2024, C
4/9/2024, 4/10/2024, B
How do I achieve that?
Last edited: