joining multiple columns of populated results into one

[excelNewbie22]

hi,

i've dozens of columns like the example below,

any way to join them into one but with the formulas, not just the values?

or

placing each formula in an even distance from each other, like each 210 rows

test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	1	2	3	4	5	6	7	8						28	28	wanted result
2														1-2-3-4-5-6	11-12-13-14-15-16	1-2-3-4-5-6
3	11	12	13	14	15	16	17	18						1-2-3-4-5-7	11-12-13-14-15-17	1-2-3-4-5-7
4														1-2-3-4-6-7	11-12-13-14-16-17	1-2-3-4-6-7
5														1-2-3-5-6-7	11-12-13-15-16-17	1-2-3-5-6-7
6														1-2-4-5-6-7	11-12-14-15-16-17	1-2-4-5-6-7
7														1-3-4-5-6-7	11-13-14-15-16-17	1-3-4-5-6-7
8														2-3-4-5-6-7	12-13-14-15-16-17	2-3-4-5-6-7
9														1-2-3-4-5-8	11-12-13-14-15-18	1-2-3-4-5-8
10														1-2-3-4-6-8	11-12-13-14-16-18	1-2-3-4-6-8
11														1-2-3-5-6-8	11-12-13-15-16-18	1-2-3-5-6-8
12														1-2-4-5-6-8	11-12-14-15-16-18	1-2-4-5-6-8
13														1-3-4-5-6-8	11-13-14-15-16-18	1-3-4-5-6-8
14														2-3-4-5-6-8	12-13-14-15-16-18	2-3-4-5-6-8
15														1-2-3-4-7-8	11-12-13-14-17-18	1-2-3-4-7-8
16														1-2-3-5-7-8	11-12-13-15-17-18	1-2-3-5-7-8
17														1-2-4-5-7-8	11-12-14-15-17-18	1-2-4-5-7-8
18														1-3-4-5-7-8	11-13-14-15-17-18	1-3-4-5-7-8
19														2-3-4-5-7-8	12-13-14-15-17-18	2-3-4-5-7-8
20														1-2-3-6-7-8	11-12-13-16-17-18	1-2-3-6-7-8
21														1-2-4-6-7-8	11-12-14-16-17-18	1-2-4-6-7-8
22														1-3-4-6-7-8	11-13-14-16-17-18	1-3-4-6-7-8
23														2-3-4-6-7-8	12-13-14-16-17-18	2-3-4-6-7-8
24														1-2-5-6-7-8	11-12-15-16-17-18	1-2-5-6-7-8
25														1-3-5-6-7-8	11-13-15-16-17-18	1-3-5-6-7-8
26														2-3-5-6-7-8	12-13-15-16-17-18	2-3-5-6-7-8
27														1-4-5-6-7-8	11-14-15-16-17-18	1-4-5-6-7-8
28														2-4-5-6-7-8	12-14-15-16-17-18	2-4-5-6-7-8
29														3-4-5-6-7-8	13-14-15-16-17-18	3-4-5-6-7-8
30																11-12-13-14-15-16
31																11-12-13-14-15-17
32																11-12-13-14-16-17
33																11-12-13-15-16-17
34																11-12-14-15-16-17
35																11-13-14-15-16-17
36																12-13-14-15-16-17
37																11-12-13-14-15-18
38																11-12-13-14-16-18
39																11-12-13-15-16-18
40																11-12-14-15-16-18
41																11-13-14-15-16-18
42																12-13-14-15-16-18
43																11-12-13-14-17-18
44																11-12-13-15-17-18
45																11-12-14-15-17-18
46																11-13-14-15-17-18
47																12-13-14-15-17-18
48																11-12-13-16-17-18
49																11-12-14-16-17-18
50																11-13-14-16-17-18
51																12-13-14-16-17-18
52																11-12-15-16-17-18
53																11-13-15-16-17-18
54																12-13-15-16-17-18
55																11-14-15-16-17-18
56																12-14-15-16-17-18
57																13-14-15-16-17-18
test

Cell Formulas
Range	Formula
N1:O1	N1	=COUNTA(N2:N9999)
N2:N29	N2	=LET(d,TOROW(A1:L1,1,1),N,6,c,COUNT(d),x,BYROW(IF(MOD(INT(SEQUENCE(2^c,,0)/2^SEQUENCE(,c,0)),2),d,""),LAMBDA(r,IF(COUNT(r)=N,TEXTJOIN("-",,r),""))),FILTER(x,x<>""))
O2:O29	O2	=LET(d,TOROW(A3:H3,1,1),N,6,c,COUNT(d),x,BYROW(IF(MOD(INT(SEQUENCE(2^c,,0)/2^SEQUENCE(,c,0)),2),d,""),LAMBDA(r,IF(COUNT(r)=N,TEXTJOIN("-",,r),""))),FILTER(x,x<>""))
P2:P29	P2	=LET(d,TOROW(A1:L1,1,1),N,6,c,COUNT(d),x,BYROW(IF(MOD(INT(SEQUENCE(2^c,,0)/2^SEQUENCE(,c,0)),2),d,""),LAMBDA(r,IF(COUNT(r)=N,TEXTJOIN("-",,r),""))),FILTER(x,x<>""))
P30:P57	P30	=LET(d,TOROW(A3:H3,1,1),N,6,c,COUNT(d),x,BYROW(IF(MOD(INT(SEQUENCE(2^c,,0)/2^SEQUENCE(,c,0)),2),d,""),LAMBDA(r,IF(COUNT(r)=N,TEXTJOIN("-",,r),""))),FILTER(x,x<>""))
Dynamic array formulas.

 

[excelNewbie22]

thanks! again!

 

[Fluff]

You're welcome.