Getting Begin and End Dates from a Grid

Question

Hello,

My data is organized with a unique code in the first column and then a date grid as below.

Code2023-03-092023-03-162023-03-232023-03-302023-04-062023-04-132023-04-202023-04-272023-05-04123xxx xx   456 xxx  xxx789   xxx   101xx xx xx 102   xxx   103xxxxx xx

I would like to transform the data to give me the begin and end dates of each wave/iteration. There is not a need for more than 3 waves. I would like the data to look like this once complete.

CodeWave 1 StartWave 2 EndWave 2 StartWave 2 EndWave 3 StartWave 3 End1232023-03-092023-03-232023-04-062023-04-13  4562023-03-162023-03-302023-04-202023-05-04  7892023-03-302023-04-13    1012023-03-092023-03-162023-03-302023-04-062023-04-202023-04-271022023-03-302023-04-13    1032023-03-092023-04-062023-04-202023-04-27

Thank you for any assistance!

Felipe_Ribeir0 · Answer

Hi @RBoyd

One way of doing this

Getting Begin and End Dates from a Grid.yxmd

RBoyd · Answer

Absolutely. The X under each date signifies that that code is active for that week. So a wave would consist of consecutive weeks in which an X is present.  For instance, in the initial table i posted code 123 would have 2 waves as there is 2 strings of consecutive x's present.

RBoyd · Answer