Home > Mobile >  Excel : How to merge two dynamic arrays into one dynamic array, with alternating rows?
Excel : How to merge two dynamic arrays into one dynamic array, with alternating rows?

Time:01-13

I have two dynamic arrays, A1# and B1#. I want to combine them into a dynamic array, C1#, like so:

Column A Column B Column C
x 4 x
y 5 4
z 6 y
5 ...

Currently, I am using the solution provided via WeAreOne's answer to enter image description here


• Formula used in cell C2

=DROP(TOCOL(A:B,3),2)

As enter image description here


• Formula used in cell C2

=TOCOL(A2#:B2#,3)

  • Related