What I'm trying to do is to join few arrays of dates.
For start, I have start date and amount of months I want to generate.
Which I did by using =ARRAYFORMULA(DATE(YEAR(A2), MONTH(A2) + SEQUENCE(C2, 1, 0, 1), 1))
formula, where A2
is start date and C2
is amount of months to generate.
Formula I cannot come up to is to do same for all existing rows and join all generated arrays of dates in a single column.
Also, I'd like to copy some columns next to every date to identify from which row it is. I have done this by formula =TRANSPOSE(SPLIT(JOIN(",", ARRAYFORMULA(REPT(SPLIT(D2,",")&",", C2))), ","))
which I found in google.
Also, here is what I have reached so far and you can test your versions too.