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
• Formula used in cell C2
=DROP(TOCOL(A:B,3),2)
• Formula used in cell C2
=TOCOL(A2#:B2#,3)