Forum Discussion

leolo7's avatar
leolo7
Copper Contributor
Dec 02, 2021

Combine two matrix one under the other

Hi, I have two tables : [Group_A], [Group_B]. I want to put all the data of each other in one table. I want to use formulas because each table might grow over the time. The purpose is to analyse the...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 02, 2021

leolo7 

If your Excel supports dynamic arrays that could be

=LET(
  rA,        ROWS(T_Result_A),
  rB,        ROWS(T_Result_B),
  clmns,     COLUMNS(T_Result_A),
  k,          SEQUENCE(rA+rB, clmns),
  i,          INT( (k-1)/clmns)+1,
  j,          MOD(k-1, 5) +1,
 IF( i <= rA, INDEX(T_Result_A, i, j),  INDEX(T_Result_B, i-rA, j) ) )
  • leolo7's avatar
    leolo7
    Copper Contributor
    Dec 02, 2021
    Hi,
    Wow, I like that, very simple. Is it possible that the output will a dynamic array? Or can we transform this in a Dynamic array? If yes, can we define Headers?
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 04, 2021

      leolo7 

      Sorry, I didn't catch. Output is the spill, aka dynamic array.

Resources