If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

ARRAY2DTO1D

Thread starter RicoS
Start date Mar 4, 2021

=ARRAY2DTO1D(array)

array: array to be transformed

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

RicoS

Board Regular

Mar 4, 2021

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

Excel Formula:

=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