ARRAY2DTO1D

[RicoS]

ARRAY2DTO1D Returns a stacked 1D array from a 2D array.

=LAMBDA(array,
   LET(
      a,array,
      col,COLUMNS(a),
      s,SEQUENCE(ROWS(a)*col,1,0),
      c,MOD(s,col)+1,
      r,INT(s/col)+1,
      return,INDEX(a,r,c),
   return)
)

Lambda - Last Cell and Split.xlsx
	B	C	D	E	F	G
1	Original Array				Resized array
2	54	44	93		54
3	48	95	90		44
4	59	82	80		93
5	12	80	41		48
6					95
7					90
8					59
9					82
10					80
11					12
12					80
13					41
Sheet1

Cell Formulas
Range	Formula
B2:D5	B2	=RANDARRAY(4,3,10,100,TRUE)
F2:F13	F2	=ARRAY2DTO1D(B2#)
Dynamic array formulas.