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)

