Single Spill Array Formula with Transpose function

[ExcelNewbie2020]

would it be possible to have a single spill array formula for my transpose formula in column D "=TRANSPOSE(SEQUENCE(B2-A2+1,1,A2))" ? and have it arrange vertically (all in single column)? thank you

From

To

15-Sep-2025​

5-Oct-2025​

15-09-25​

16-09-25​

17-09-25​

18-09-25​

19-09-25​

45920​

45921​

45922​

45923​

45924​

45925​

45926​

45927​

45928​

45929​

45930​

45931​

45932​

45933​

45934​

45935​

18-Oct-2025​

28-Oct-2025​

18-10-25​

19-10-25​

20-10-25​

21-10-25​

22-10-25​

45953​

45954​

45955​

45956​

45957​

45958​

28-Oct-2025​

31-Oct-2025​

28-10-25​

29-10-25​

30-10-25​

31-10-25​

31-Oct-2025​

3-Nov-2025​

31-10-25​

01-11-25​

02-11-25​

03-11-25​

31-Oct-2025​

15-Nov-2025​

31-10-25​

01-11-25​

02-11-25​

03-11-25​

04-11-25​

45966​

45967​

45968​

45969​

45970​

45971​

45972​

45973​

45974​

45975​

45976​

Note: I can't paste the mini sheet

 

[hagia_sofia]

Hello, one option could be:

=LET(
a,A2:A6,
b,B2:B6,
c,SEQUENCE(ROWS(a)),
IFNA(DROP(REDUCE("",c,LAMBDA(x,y,VSTACK(x,SEQUENCE(,INDEX(b,y,0)-INDEX(a,y,0)+1,INDEX(a,y,0))))),1),""))

 

[djclements]

Another possibility:

=LET(
    frm, A2:A6,
    to,  B2:B6,
    dur, MAX(to-frm),
    end, frm+dur,
    beg, MIN(frm),
    seq, SEQUENCE(, MAX(end)-beg+1, beg),
    WRAPROWS(TOCOL(IFS(frm<=seq, IF(to>=seq, seq, IF(end>=seq, "", NA()))), 2), dur+1)
)