=CombineArray()
and...
=CHOOSE({1;2},TRANSPOSE(List1),TRANSPOSE(List2))
File: http://www.interactiveds.com.au/software/CombineArray.xls
Source: link
and...
=CHOOSE({1;2},TRANSPOSE(List1),TRANSPOSE(List2))
File: http://www.interactiveds.com.au/software/CombineArray.xls
Source: link