INSRWS

[Xlambda]

INSRWS Inserts blank Rows. Calls ZINS
- can insert 1 or more blank rows, called "gap", after each group of r rows. Gap size argument g
- if g<0 a nr. of abs(g) blank rows is also inserted before 1st row
Note: Could have embedded ZINS function with INSRWS but can be a useful function tool to solve other types of tasks, like inserting text patterns.

=LAMBDA(a, [r], [g],
    LET(
        x, MAX(1, r),
        y, IF(g, ABS(g), 1),
        q, ZINS(ROWS(a), x, y),
        s, IF(g < 0, VSTACK(SEQUENCE(y) ^ 0 - 1, q), q),
        b, INDEX(IF(a = "", "", a), s, SEQUENCE(, COLUMNS(a))),
        IF(s, b, "")
    )
)

ZINS(n,x,g) Zeros Insert, Inserts 1 or more zeros to a sequence of n elements
n: nr. of elements
x: element's group size
g: 0's group size

=LAMBDA(n, x, g,
    LET(
        d, IF(SEQUENCE(x) < x, ",", "," & REPT("0,", g)),
        --TEXTSPLIT(TEXTJOIN(d, , SEQUENCE(n)), , ",")
    )
)

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1
2						r,g,omit.				r,2, g,omit.				r,omit. ,g,2				r,3,g,2				r,5,g,3				r,omit. ,g,-1				r,4,g,-3
3		a				=INSRWS(B4#)				=INSRWS(B4#,2)				=INSRWS(B4#,,2)				=INSRWS(B4#,3,2)				=INSRWS(B4#,5,3)				=INSRWS(B4#,,-1)				=INSRWS(B4#,4,-3)
4		1	2	3		1	2	3		1	2	3		1	2	3		1	2	3		1	2	3
5		4	5	6						4	5	6						4	5	6		4	5	6		1	2	3
6		7	8	9		4	5	6										7	8	9		7	8	9
7		10	11	12						7	8	9		4	5	6						10	11	12		4	5	6		1	2	3
8		13	14	15		7	8	9		10	11	12										13	14	15						4	5	6
9		16	17	18														10	11	12						7	8	9		7	8	9
10		19	20	21		10	11	12		13	14	15		7	8	9		13	14	15										10	11	12
11		22	23	24						16	17	18						16	17	18						10	11	12
12		25	26	27		13	14	15														16	17	18
13		28	29	30						19	20	21		10	11	12						19	20	21		13	14	15
14		31	32	33		16	17	18		22	23	24						19	20	21		22	23	24						13	14	15
15		34	35	36														22	23	24		25	26	27		16	17	18		16	17	18
16		37	38	39		19	20	21		25	26	27		13	14	15		25	26	27		28	29	30						19	20	21
17		40	41	42						28	29	30														19	20	21		22	23	24
18		43	44	45		22	23	24
19		46	47	48						31	32	33		16	17	18		28	29	30						22	23	24
20		49	50	51		25	26	27		34	35	36						31	32	33		31	32	33
21																		34	35	36		34	35	36		25	26	27		25	26	27
22						28	29	30		37	38	39		19	20	21						37	38	39						28	29	30
23										40	41	42										40	41	42		28	29	30		31	32	33
24						31	32	33										37	38	39		43	44	45						34	35	36
25										43	44	45		22	23	24		40	41	42						31	32	33
26						34	35	36		46	47	48						43	44	45
27																										34	35	36
28						37	38	39		49	50	51		25	26	27						46	47	48						37	38	39
29																		46	47	48		49	50	51		37	38	39		40	41	42
30						40	41	42										49	50	51										43	44	45
31														28	29	30										40	41	42		46	47	48
32						43	44	45
33																										43	44	45
34						46	47	48						31	32	33
35																										46	47	48		49	50	51
36						49	50	51
37														34	35	36										49	50	51
38
39
40														37	38	39
41
42
43														40	41	42
44
45
46														43	44	45
47
48
49														46	47	48
50
51
52														49	50	51
53
Sheet1

Cell Formulas
Range	Formula
F3,J3,N3,R3,V3,Z3,AD3	F3	=FORMULATEXT(F4)
B4:D20	B4	=SEQUENCE(17,3)
F4:H36	F4	=INSRWS(B4#)
J4:L28	J4	=INSRWS(B4#,2)
N4:P52	N4	=INSRWS(B4#,,2)
R4:T30	R4	=INSRWS(B4#,3,2)
V4:X29	V4	=INSRWS(B4#,5,3)
Z4:AB37	Z4	=INSRWS(B4#,,-1)
AD4:AF35	AD4	=INSRWS(B4#,4,-3)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:AF53	Expression	=B4<>""	text	NO
B4:AF52	Expression	="b4<>"""""	text	NO
B4:AF52	Expression	="B4<>"""""	text	NO

 

[Xlambda]

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	ZINS Concept
2						delimiter pattern		3. j=textjoin(d,,q)
3						for TEXTJOIN		=TEXTJOIN(F13#,,C6#)
4			q=seq(n)			1. s=seq(x)		1,2,3,0,0,4,5,6,0,0,7,8,9,0,0,10,11,12,0,0,13
5	nr. elements (n)		=SEQUENCE(A6)			=SEQUENCE(A9)
6	13		1			1		4. t=--textsplit(j,,",")			n,13,x,3,g,2		n,13,x,4,g,3
7			2			2		=--TEXTSPLIT(H4,,",")			=ZINS(13,3,2)		=ZINS(13,4,3)
8	elm's group size (x)		3			3		1			1		1
9	3		4					2			2		2
10			5					3			3		3
11	0's group size (g)		6		2.d=if(s<x,",",","&rept("0,",g))			0			0		4
12	2		7		=IF(F6#<A9,",",","&REPT("0,",A12))			0			0		0
13			8			,		4			4		0
14			9			,		5			5		0
15			10			,0,0,		6			6		5
16			11					0			0		6
17			12					0			0		7
18			13					7			7		8
19								8			8		0
20								9			9		0
21								0			0		0
22								0			0		9
23								10			10		10
24								11			11		11
25								12			12		12
26								0			0		0
27								0			0		0
28								13			13		0
29													13
30
Sheet2

Cell Formulas
Range	Formula
H3,K7,M7,H7,F5,C5	H3	=FORMULATEXT(H4)
H4	H4	=TEXTJOIN(F13#,,C6#)
C6:C18	C6	=SEQUENCE(A6)
F6:F8	F6	=SEQUENCE(A9)
H8:H28	H8	=--TEXTSPLIT(H4,,",")
K8:K28	K8	=ZINS(13,3,2)
M8:M29	M8	=ZINS(13,4,3)
E12	E12	=FORMULATEXT(F13)
F13:F15	F13	=IF(F6#<A9,",",","&REPT("0,",A12))
Dynamic array formulas.

 

[Xlambda]

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1		INSRWS Concept
2								Note: when an argument is omitted, value asigned acts like a blank, a 0 or "" on the same time
3								Knowing this, on most cases is needless to use ISOMITTED
4		=LAMBDA(a,[r],[g], LET( x, MAX(1, r), y, IF(g, ABS(g), 1), q, ZINS(ROWS(a), x, y), s, IF(g < 0, VSTACK(SEQUENCE(y) ^ 0 - 1, q), q), b, INDEX(IF(a = "", "", a), s, SEQUENCE(, COLUMNS(a))), IF(s, b, "") ) )
5
6								<= if r,omitted or 0, or <0 x=1, otherwise x=r
7								<= if g, omitted or 0, y=1, if<0 y=abs(g), if>0 y=g
8								<= ZINS creates index pattern, 0's for gaps location
9								<= only if g<0, stacks abs(g) nr. of 0's to the top of the index patten
10								<= index and returning empty strings and not 0's if initial array has blanks
11								<= placing blank rows that corespond to 0's distribution
12
13
14
15									=INSRWS(E16:G27,3,2)				=INSRWS(E16:G27,3,-2)
16			blanks		A	0	3		A	0	3
17			empty strings		4	5	6		4	5	6
18			0's				9				9		A	0	3
19					10	11	0						4	5	6
20					13	14	15								9
21					16		18		10	11	0
22					19	20	21		13	14	15
23						23			16		18		10	11	0
24					25	26	27						13	14	15
25					0	29	30						16		18
26					C	32	B		19	20	21
27					34	ABC	36			23
28									25	26	27		19	20	21
29														23
30													25	26	27
31									0	29	30
32									C	32	B
33									34	ABC	36		0	29	30
34													C	32	B
35													34	ABC	36
36
Sheet3

Cell Formulas
Range	Formula
I15,M15	I15	=FORMULATEXT(I16)
I16:K33	I16	=INSRWS(E16:G27,3,2)
M16:O35	M16	=INSRWS(E16:G27,3,-2)
F18,E23	F18	=""
Dynamic array formulas.

 

[Xlambda]

ADVINS Advance Insert, inserts blank rows/columns, can add row/column headers, Calls INSRWS that calls ZINS. 100% cosmetics function, double transpose and headers stacking versatility.
Note: Initially chose as function name INSERT (identical to the one beneath). Function accepted by Name Manager as any function. When called, an error message pops: "That function isn't valid". Looks like a new built-in function is coming, and probably will be a text function. Will see.
ADVINS(ar,[rc],[g],[h])
ar: array
[rc]: rows/clms group size, orientation given by its sign
rc<0, column orientation, rc>0 rows orientation, if omitted rc=1
[g]: gap size, if omitted g=1, if<0 gap inserted also before 1st row or 1st clm
[h]:row/column headers array, if omitted no stacking

=LAMBDA(ar, [rc], [g], [h],
    LET(
        a, IF(ar = "", "", ar),
        x, IF(rc, ABS(rc), 1),
        f, rc < 0,
        b, IF(f, TRANSPOSE(a), a),
        c, INSRWS(b, x, g),
        d, IF(f, TRANSPOSE(c), c),
        IF(AND(h = ""), d, IF(f, HSTACK(h, d), VSTACK(h, d)))
    )
)

Book3 (version 1).xlsb.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
1
2							rc>0, rows orientation
3	h	A	B	C	D
4							=ADVINS(B5:E16)					=ADVINS(B5:E16,,-1)					=ADVINS(B5:E16,,,B3:E3)					=ADVINS(B5:E16,,-1,B3:E3)					=ADVINS(B5:E16,3,2,B3:E3)					=ADVINS(B5:E16,3,-2,B3:E3)
5	ar	1	2	3	4		1	2	3	4							A	B	C	D		A	B	C	D		A	B	C	D		A	B	C	D
6		5	6	7	8							1	2	3	4		1	2	3	4							1	2	3	4
7		9	10	11	12		5	6	7	8												1	2	3	4		5	6	7	8
8		13	14	15	16							5	6	7	8		5	6	7	8							9	10	11	12		1	2	3	4
9		17	18	19	20		9	10	11	12												5	6	7	8							5	6	7	8
10		21	22	23	24							9	10	11	12		9	10	11	12												9	10	11	12
11		25	26	27	28		13	14	15	16												9	10	11	12		13	14	15	16
12		29	30	31	32							13	14	15	16		13	14	15	16							17	18	19	20
13		33	34	35	36		17	18	19	20												13	14	15	16		21	22	23	24		13	14	15	16
14		37	38	39	40							17	18	19	20		17	18	19	20												17	18	19	20
15		41	42	43	44		21	22	23	24												17	18	19	20							21	22	23	24
16		45	46	47	48							21	22	23	24		21	22	23	24							25	26	27	28
17							25	26	27	28												21	22	23	24		29	30	31	32
18												25	26	27	28		25	26	27	28							33	34	35	36		25	26	27	28
19							29	30	31	32												25	26	27	28							29	30	31	32
20												29	30	31	32		29	30	31	32												33	34	35	36
21							33	34	35	36												29	30	31	32		37	38	39	40
22												33	34	35	36		33	34	35	36							41	42	43	44
23							37	38	39	40												33	34	35	36		45	46	47	48		37	38	39	40
24												37	38	39	40		37	38	39	40												41	42	43	44
25							41	42	43	44												37	38	39	40							45	46	47	48
26												41	42	43	44		41	42	43	44
27							45	46	47	48												41	42	43	44
28												45	46	47	48		45	46	47	48
29																						45	46	47	48
30
Sheet4

Cell Formulas
Range	Formula
G4,L4,Q4,V4,AA4,AF4	G4	=FORMULATEXT(G5)
B5:E16	B5	=SEQUENCE(12,4)
G5:J27	G5	=ADVINS(B5:E16)
L5:O28	L5	=ADVINS(B5:E16,,-1)
Q5:T28	Q5	=ADVINS(B5:E16,,,B3:E3)
V5:Y29	V5	=ADVINS(B5:E16,,-1,B3:E3)
AA5:AD23	AA5	=ADVINS(B5:E16,3,2,B3:E3)
AF5:AI25	AF5	=ADVINS(B5:E16,3,-2,B3:E3)
Dynamic array formulas.

 

[Xlambda]

Book3 (version 1).xlsb.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM
1
2																		rc<0 column orientation
3		h		ar														=ADVINS(D4#,-3,-2,B4:B10)
4		A		1	2	3	4	5	6	7	8	9	10	11	12			A			1	2	3			4	5	6			7	8	9			10	11	12
5		B		13	14	15	16	17	18	19	20	21	22	23	24			B			13	14	15			16	17	18			19	20	21			22	23	24
6		C		25	26	27	28	29	30	31	32	33	34	35	36			C			25	26	27			28	29	30			31	32	33			34	35	36
7		D		37	38	39	40	41	42	43	44	45	46	47	48			D			37	38	39			40	41	42			43	44	45			46	47	48
8		E		49	50	51	52	53	54	55	56	57	58	59	60			E			49	50	51			52	53	54			55	56	57			58	59	60
9		F		61	62	63	64	65	66	67	68	69	70	71	72			F			61	62	63			64	65	66			67	68	69			70	71	72
10		G		73	74	75	76	77	78	79	80	81	82	83	84			G			73	74	75			76	77	78			79	80	81			82	83	84
11
12				=ADVINS(D4#,-1)
13				1		2		3		4		5		6		7		8		9		10		11		12
14				13		14		15		16		17		18		19		20		21		22		23		24
15				25		26		27		28		29		30		31		32		33		34		35		36
16				37		38		39		40		41		42		43		44		45		46		47		48
17				49		50		51		52		53		54		55		56		57		58		59		60
18				61		62		63		64		65		66		67		68		69		70		71		72
19				73		74		75		76		77		78		79		80		81		82		83		84
20
21				=ADVINS(D4#,-1,-1)
22					1		2		3		4		5		6		7		8		9		10		11		12
23					13		14		15		16		17		18		19		20		21		22		23		24
24					25		26		27		28		29		30		31		32		33		34		35		36
25					37		38		39		40		41		42		43		44		45		46		47		48
26					49		50		51		52		53		54		55		56		57		58		59		60
27					61		62		63		64		65		66		67		68		69		70		71		72
28					73		74		75		76		77		78		79		80		81		82		83		84
29
30				=ADVINS(D4#,-4,3,B4:B10)
31				A	1	2	3	4				5	6	7	8				9	10	11	12
32				B	13	14	15	16				17	18	19	20				21	22	23	24
33				C	25	26	27	28				29	30	31	32				33	34	35	36
34				D	37	38	39	40				41	42	43	44				45	46	47	48
35				E	49	50	51	52				53	54	55	56				57	58	59	60
36				F	61	62	63	64				65	66	67	68				69	70	71	72
37				G	73	74	75	76				77	78	79	80				81	82	83	84
38
39				=ADVINS(D4#,-4,-3,B4:B10)
40				A				1	2	3	4				5	6	7	8				9	10	11	12
41				B				13	14	15	16				17	18	19	20				21	22	23	24
42				C				25	26	27	28				29	30	31	32				33	34	35	36
43				D				37	38	39	40				41	42	43	44				45	46	47	48
44				E				49	50	51	52				53	54	55	56				57	58	59	60
45				F				61	62	63	64				65	66	67	68				69	70	71	72
46				G				73	74	75	76				77	78	79	80				81	82	83	84
47
Sheet5

Cell Formulas
Range	Formula
R3,D39,D30,D21,D12	R3	=FORMULATEXT(R4)
D4:O10	D4	=SEQUENCE(7,12)
R4:AL10	R4	=ADVINS(D4#,-3,-2,B4:B10)
D13:Z19	D13	=ADVINS(D4#,-1)
D22:AA28	D22	=ADVINS(D4#,-1,-1)
D31:V37	D31	=ADVINS(D4#,-4,3,B4:B10)
D40:Y46	D40	=ADVINS(D4#,-4,-3,B4:B10)
Dynamic array formulas.

 

[Xlambda]

Introducing ARRINS Arrays Insert, "intercalates" rows or columns of 2 arrays. Examples will speak for themselves.
Arrays should be proportionate by nr. of elements and to share one dimension. Inserting parameters are calculated implicitly.
ARRINS(ar,br,[rc],[h]) Calls ADVINS
ar: array to receive the insert
br: array to be inserted
[rc]: rows/columns orientation, if omitted or 0, by rows, if 1 by columns
[h]: headers array

=LAMBDA(ar, br, [rc], [h],
    LET(
        a, IF(ar = "", "", ar),
        b, IF(br = "", "", br),
        o, IF(rc, -1, 1),
        k, o * COUNTA(a) / COUNTA(b),
        x, ADVINS(a, k),
        v, IFNA(IF(rc, HSTACK(x, ""), VSTACK(x, "")), ""),
        y, ADVINS(b, o * 1, -ABS(k)),
        z, IF(v = "", y, v),
        IF(AND(h = ""), z, IF(rc, HSTACK(h, z), VSTACK(h, z)))
    )
)

Book3 (version 1).xlsb.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1						ARRINS by rows
2		Wkdy	wk nr.	Val
3				1				2		=ARRINS(B4:D10,F4:H10)				=ARRINS(J4#,F13:H19)				=ARRINS(N4#,B23#,,B2:D2)
4		Mon	w1	23		Mon	w2	31		Mon	w1	23		Mon	w1	23		Wkdy	wk nr.	Val
5		Tue	w1	45		Tue	w2	57		Mon	w2	31		Mon	w2	31		Mon	w1	23
6		Wed	w1	42		Wed	w2	64		Tue	w1	45		Mon	w3	23		Mon	w2	31
7		Thu	w1	76		Thu	w2	46		Tue	w2	57		Tue	w1	45		Mon	w3	23
8		Fri	w1	56		Fri	w2	80		Wed	w1	42		Tue	w2	57		Tot		77
9		Sat	w1	81		Sat	w2	33		Wed	w2	64		Tue	w3	45		Tue	w1	45
10		Sun	w1	74		Sun	w2	37		Thu	w1	76		Wed	w1	42		Tue	w2	57
11										Thu	w2	46		Wed	w2	64		Tue	w3	45
12								3		Fri	w1	56		Wed	w3	42		Tot		147
13						Mon	w3	23		Fri	w2	80		Thu	w1	76		Wed	w1	42
14						Tue	w3	45		Sat	w1	81		Thu	w2	46		Wed	w2	64
15						Wed	w3	42		Sat	w2	33		Thu	w3	76		Wed	w3	42
16						Thu	w3	76		Sun	w1	74		Fri	w1	56		Tot		148
17						Fri	w3	56		Sun	w2	37		Fri	w2	80		Thu	w1	76
18						Sat	w3	81						Fri	w3	56		Thu	w2	46
19						Sun	w3	74						Sat	w1	81		Thu	w3	76
20														Sat	w2	33		Tot		198
21		Totals/array's rows												Sat	w3	81		Fri	w1	56
22		=IFNA(HSTACK(REPT("Tot",SEQUENCE(7)^0),"",D4:D10+H4:H10+H13:H19),"")												Sun	w1	74		Fri	w2	80
23		Tot		77										Sun	w2	37		Fri	w3	56
24		Tot		147										Sun	w3	74		Tot		192
25		Tot		148														Sat	w1	81
26		Tot		198														Sat	w2	33
27		Tot		192														Sat	w3	81
28		Tot		195														Tot		195
29		Tot		185														Sun	w1	74
30																		Sun	w2	37
31																		Sun	w3	74
32																		Tot		185
33
Sheet6

Cell Formulas
Range	Formula
J3,N3,B22,R3	J3	=FORMULATEXT(J4)
J4:L17	J4	=ARRINS(B4:D10,F4:H10)
N4:P24	N4	=ARRINS(J4#,F13:H19)
R4:T32	R4	=ARRINS(N4#,B23#,,B2:D2)
B23:D29	B23	=IFNA(HSTACK(REPT("Tot",SEQUENCE(7)^0),"",D4:D10+H4:H10+H13:H19),"")
Dynamic array formulas.

 

[Xlambda]

Book3.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1		ARRINS by columns
2						1				2				3
3		A	-10	-8	-6	-4	1	4	7	10	10	13	16	19
4		B	-2	0	2	4	13	16	19	22	22	25	28	31
5		C	6	8	10	12	25	28	31	34	34	37	40	43
6		D	14	16	18	20	37	40	43	46	46	49	52	55
7		E	22	24	26	28	49	52	55	58	58	61	64	67
8		F	30	32	34	36	61	64	67	70	70	73	76	79
9		G	38	40	42	44	73	76	79	82	82	85	88	91
10
11		Calculating totals byrow for each array using iterations and second syntax of INDEX with area_num, single cell formula.
12		=DROP(REDUCE(0,SEQUENCE(3),LAMBDA(v,i,HSTACK(v,BYROW(INDEX((C3#,G3#,K3#),SEQUENCE(7),SEQUENCE(,4),i),LAMBDA(x,SUM(x)))))),,1)
13			-28	22	58
14			4	70	106
15			36	118	154
16			68	166	202
17			100	214	250
18			132	262	298
19			164	310	346
20
21		=ARRINS(C3:N9,C13#,1,B3:B9)
22		A	-10	-8	-6	-4	-28	1	4	7	10	22	10	13	16	19	58
23		B	-2	0	2	4	4	13	16	19	22	70	22	25	28	31	106
24		C	6	8	10	12	36	25	28	31	34	118	34	37	40	43	154
25		D	14	16	18	20	68	37	40	43	46	166	46	49	52	55	202
26		E	22	24	26	28	100	49	52	55	58	214	58	61	64	67	250
27		F	30	32	34	36	132	61	64	67	70	262	70	73	76	79	298
28		G	38	40	42	44	164	73	76	79	82	310	82	85	88	91	346
29
Sheet7

Cell Formulas
Range	Formula
C3:F9	C3	=SEQUENCE(7,4,-10,2)
G3:J9	G3	=SEQUENCE(7,4,,3)
K3:N9	K3	=SEQUENCE(7,4,10,3)
B12	B12	=FORMULATEXT(C13)
C13:E19	C13	=DROP(REDUCE(0,SEQUENCE(3),LAMBDA(v,i,HSTACK(v,BYROW(INDEX((C3#,G3#,K3#),SEQUENCE(7),SEQUENCE(,4),i),LAMBDA(x,SUM(x)))))),,1)
B21	B21	=FORMULATEXT(B22)
B22:Q28	B22	=ARRINS(C3:N9,C13#,1,B3:B9)
Dynamic array formulas.

 

[Xlambda]

Forgot to post alternative of ZINS function, identical functionality with the previous one, based on same concept I posted here on Suat's thread that inspired all this: INSERTBLANKAT
For large arrays, this version is better.

=LAMBDA(n, x, g, LET(t, TOCOL(IFNA(EXPAND(WRAPROWS(SEQUENCE(n), x), , g + x), 0)), TAKE(t, XMATCH(n, t))))

 

[Xlambda]

If arrays on same spreadsheet can be called by an iterative formula using INDEX area_num syntax, this cannot be done if arrays are on different spreadsheets. For that here we have
NARRINS N Arrays Insert function that can insert a sequence of min 2, max 5 arrays that can be located anywhere.
NARRINS(rc,h,a,b,[c],[d],[e])
rs: row/clm orientation
h: headers array
a,b,c,d,e: arrays to be inserted, when c,d,or e are omitted, function knows to calculate the nr. of arrays involved.

=LAMBDA(rc, h, a, b, [c], [d], [e],
    LET(
        x, LAMBDA(i, SWITCH(i, 1, a, 2, b, 3, c, 4, d, 5, e)),
        t, VSTACK(TYPE(c), TYPE(d), TYPE(e)),
        m, IFNA(XMATCH(1, t), 4) + 1,
        REDUCE(
            a,
            SEQUENCE(m - 1, , 2),
            LAMBDA(v, i, ARRINS(v, x(i), rc, IF(i = m, h, "")))
        )
    )
)

Book3.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1						NARRINS by rows. All formulas single cell based only on initial arrays. 1,2,3,4, or 5												Totals/array's rows
2		Wkdy	wk nr.	Val														=IFNA(HSTACK(REPT("Tot",SEQUENCE(7)^0),"",D4:D10+H4:H10+L4:L10+P4:P10),"")
3				1				2				3				4				5
4		Mon	w1	23		Mon	w2	31		Mon	w3	23		Mon	w4	60		Tot		137
5		Tue	w1	45		Tue	w2	57		Tue	w3	45		Tue	w4	70		Tot		217
6		Wed	w1	42		Wed	w2	64		Wed	w3	42		Wed	w4	33		Tot		181
7		Thu	w1	76		Thu	w2	46		Thu	w3	76		Thu	w4	44		Tot		242
8		Fri	w1	56		Fri	w2	80		Fri	w3	56		Fri	w4	78		Tot		270
9		Sat	w1	81		Sat	w2	33		Sat	w3	81		Sat	w4	12		Tot		207
10		Sun	w1	74		Sun	w2	37		Sun	w3	74		Sun	w4	43		Tot		228
11
12										=NARRINS(,B2:D2,B4:D10,F4:H10,J4:L10)
13										↓↓↓				=NARRINS(,B2:D2,B4:D10,F4:H10,J4:L10,N4:P10)
14					=NARRINS(,B2:D2,B4:D10,F4:H10)					↓↓↓				↓↓↓				=NARRINS(,B2:D2,B4:D10,F4:H10,J4:L10,N4:P10,R4#)
15		=NARRINS(,,B4:D10,F4:H10)				Wkdy	wk nr.	Val		Wkdy	wk nr.	Val		Wkdy	wk nr.	Val		Wkdy	wk nr.	Val
16		Mon	w1	23		Mon	w1	23		Mon	w1	23		Mon	w1	23		Mon	w1	23
17		Mon	w2	31		Mon	w2	31		Mon	w2	31		Mon	w2	31		Mon	w2	31
18		Tue	w1	45		Tue	w1	45		Mon	w3	23		Mon	w3	23		Mon	w3	23
19		Tue	w2	57		Tue	w2	57		Tue	w1	45		Mon	w4	60		Mon	w4	60
20		Wed	w1	42		Wed	w1	42		Tue	w2	57		Tue	w1	45		Tot		137
21		Wed	w2	64		Wed	w2	64		Tue	w3	45		Tue	w2	57		Tue	w1	45
22		Thu	w1	76		Thu	w1	76		Wed	w1	42		Tue	w3	45		Tue	w2	57
23		Thu	w2	46		Thu	w2	46		Wed	w2	64		Tue	w4	70		Tue	w3	45
24		Fri	w1	56		Fri	w1	56		Wed	w3	42		Wed	w1	42		Tue	w4	70
25		Fri	w2	80		Fri	w2	80		Thu	w1	76		Wed	w2	64		Tot		217
26		Sat	w1	81		Sat	w1	81		Thu	w2	46		Wed	w3	42		Wed	w1	42
27		Sat	w2	33		Sat	w2	33		Thu	w3	76		Wed	w4	33		Wed	w2	64
28		Sun	w1	74		Sun	w1	74		Fri	w1	56		Thu	w1	76		Wed	w3	42
29		Sun	w2	37		Sun	w2	37		Fri	w2	80		Thu	w2	46		Wed	w4	33
30										Fri	w3	56		Thu	w3	76		Tot		181
31										Sat	w1	81		Thu	w4	44		Thu	w1	76
32										Sat	w2	33		Fri	w1	56		Thu	w2	46
33										Sat	w3	81		Fri	w2	80		Thu	w3	76
34										Sun	w1	74		Fri	w3	56		Thu	w4	44
35										Sun	w2	37		Fri	w4	78		Tot		242
36										Sun	w3	74		Sat	w1	81		Fri	w1	56
37														Sat	w2	33		Fri	w2	80
38														Sat	w3	81		Fri	w3	56
39														Sat	w4	12		Fri	w4	78
40														Sun	w1	74		Tot		270
41														Sun	w2	37		Sat	w1	81
42														Sun	w3	74		Sat	w2	33
43														Sun	w4	43		Sat	w3	81
44																		Sat	w4	12
45																		Tot		207
46																		Sun	w1	74
47																		Sun	w2	37
48																		Sun	w3	74
49																		Sun	w4	43
50																		Tot		228
51
Sheet8

Cell Formulas
Range	Formula
R2,N13	R2	=FORMULATEXT(R4)
R4:T10	R4	=IFNA(HSTACK(REPT("Tot",SEQUENCE(7)^0),"",D4:D10+H4:H10+L4:L10+P4:P10),"")
J12	J12	=FORMULATEXT(J15)
E14	E14	=FORMULATEXT(F15)
R14,B15	R14	=FORMULATEXT(R15)
F15:H29	F15	=NARRINS(,B2:D2,B4:D10,F4:H10)
J15:L36	J15	=NARRINS(,B2:D2,B4:D10,F4:H10,J4:L10)
N15:P43	N15	=NARRINS(,B2:D2,B4:D10,F4:H10,J4:L10,N4:P10)
R15:T50	R15	=NARRINS(,B2:D2,B4:D10,F4:H10,J4:L10,N4:P10,R4#)
B16:D29	B16	=NARRINS(,,B4:D10,F4:H10)
Dynamic array formulas.

 

[Xlambda]

Book3.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1		Concept NARRINS. Calls ARRINS
2
3		=LAMBDA(rc,h,a,b,[c],[d],[e], LET( x, LAMBDA(i, SWITCH(i, 1, a, 2, b, 3, c, 4, d, 5, e)), t, VSTACK(TYPE(c), TYPE(d), TYPE(e)), m, IFNA(XMATCH(1, t), 4) + 1, REDUCE( a, SEQUENCE(m - 1, , 2), LAMBDA(v,i, ARRINS(v, x(i), rc, IF(i = m, h, ""))) ) ) )
4
5											<= embedded lambda x(i) to index the arrays
6											<=TYPE array "t", if c,d,e are arrays => 64;64;64, if "e" omitted=> 64;64;1
7											<= based on what "t" returns we can calculate how many arrays were inputted "m"
8											<= iterative formula loops from "i"=2 to m, because accumulator's "v" first value=first array "a"
9
10											<= calls ARRINS(accumulator,x(i),rc,......),
11											and only when reaches last index nr "m", "h" array is stacked or not
12											depending if "h" headers argument is omitted or not
13
14
15
Sheet9