How to vertically concatenate multiple blocks of 'two columns' where each block is generated with a single spill from one cell?

[Rnkhch]

Hello,

This question is related to my other post here: How to spill a second column from the spill formula in one cell? (two-dimensional spill :) ?)

In that example, we were able to output two columns of data with a spill from a single cell. Now suppose that there are multiple spills, one in D1, another say in F1, another in H1, etc.

Is there a way that I can output all spills such that they are vertically concatenated with no spaces in between, so overall they would look like two longer columns of data? I tried a few things with CONCAT, but wasn't successful (and only got concatenated data inside the cell ). The reason I don't want to manually paste them under each other is that their sizes will grow over time as more data is added to the sheet. So it will be really nice to have this longer columns to adapt automatically and get longer over time .

Thanks for any input!

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	12	u		37	f	12	u	37	f	37	f
2	37	f		32	h	16	o	49	z	32	h
3	32	h		49	z	8	f	43		49	z
4	16	o		43		18	f	23		43
5	49	z		48	h	24	r	17	y	48	h
6	8	f		24	r	23		19	k	24	r
7	43			23		17	y			23
8	48	h		46	j	19	k			46	j
9	18	f		50	l					50	l
10	24	r								12	u
11	23									16	o
12	17	y								8	f
13	46	j								18	f
14	19	k								24	r
15	50	l								23
16										17	y
17										19	k
18										37	f
19										49	z
20										43
21										23
22										17	y
23										19	k
24
Main

Cell Formulas
Range	Formula
D1:E9	D1	=LET(f,FILTER(""&A1:B15,A1:A15>20),IFERROR(f+0,f))
F1:G8	F1	=LET(f,FILTER(""&A1:B15,A1:A15<25),IFERROR(f+0,f))
H1:I6	H1	=LET(f,FILTER(""&A1:B15,MOD(A1:A15,2)=1),IFERROR(f+0,f))
J1:K23	J1	=LET(ra,ROWS(D1#),rb,ra+ROWS(F1#),s,SEQUENCE(rb+ROWS(H1#)),IF(s<=ra,D1#,IF(s<=rb,INDEX(F1#,s-ra,{1,2}),INDEX(H1#,s-rb,{1,2}))))
Dynamic array formulas.

 

[Rnkhch]

Awesome! Thanks for the fast response.

 

[Peter_SSs]

If/when you have the VSTACK function ...

22 07 22.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	12	u		37	f	12	u	37	f	37	f
2	37	f		32	h	16	o	49	z	32	h
3	32	h		49	z	8	f	43		49	z
4	16	o		43		18	f	23		43
5	49	z		48	h	24	r	17	y	48	h
6	8	f		24	r	23		19	k	24	r
7	43			23		17	y			23
8	48	h		46	j	19	k			46	j
9	18	f		50	l					50	l
10	24	r								12	u
11	23									16	o
12	17	y								8	f
13	46	j								18	f
14	19	k								24	r
15	50	l								23
16										17	y
17										19	k
18										37	f
19										49	z
20										43
21										23
22										17	y
23										19	k
VSTACK

Cell Formulas
Range	Formula
D1:E9	D1	=LET(f,FILTER(""&A1:B15,A1:A15>20),IFERROR(f+0,f))
F1:G8	F1	=LET(f,FILTER(""&A1:B15,A1:A15<25),IFERROR(f+0,f))
H1:I6	H1	=LET(f,FILTER(""&A1:B15,MOD(A1:A15,2)=1),IFERROR(f+0,f))
J1:K23	J1	=VSTACK(D1#,F1#,H1#)
Dynamic array formulas.

 

[Fluff]

Glad we could help & thanks for the feedback.