Appending Dynamic Arrays

Hi everyone,

Is there any way to append dynamic arrays?

For example, imagine having two dynamic arrays:
=SEQUENCE(4,1,1,1)
and
=SEQUENCE(4,1,1,2)

So that would be:
{1,2,3,4}
and
{1,3,5,7}

Is there any formula append the second one to the first one? Getting a dynamic array {1,2,3,4,1,3,5,7}.

I plan to do this for more than two dynamic arrays.

See 'DA workbook' for my dynamic arrays and the results I am after.

P.S.

My ultimate goal is to use the start and end dates of a list of projects (see left table in 'workbook') to create a new column (inside right table) that finds the ongoing project for each date in a year. So, 'Project ID', 'Start Date' and 'End date' are what I have (blue). 'Ongoing project' is what I need (yellow).

Thank you,

Coen

What is the connection between the text and the picture?

If the picture is relevant, please upload the sheet, not a picture of the sheet.

Sheet F2
=TEXTJOIN(",",,REPT(LeftTable[Project ID],(E2>=LeftTable[Start Date])*(E2<=LeftTable[End Date])))

Sheet1 B2
=FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,A2#,B2#)&"</m></x>","//m")