Forum Discussion
Solved
Stack two columns to one with out VBA
I have 2 columns as above, column A and column B. I want them conbimed to column D without ANY manual work. Note: (1) VBA is NOT allowed (by my company policy lol). (2) You might want to cre...
As variant
with
=LET( aN, COUNTA(A:A), bN, COUNTA(B:B), k, SEQUENCE(aN+bN), IF(k<=aN, INDEX(A:A,k), INDEX(B:B, k-aN)) )
As variant
with
=LET(
aN, COUNTA(A:A),
bN, COUNTA(B:B),
k, SEQUENCE(aN+bN),
IF(k<=aN, INDEX(A:A,k), INDEX(B:B, k-aN)) )