Combine 2 or more columns into 1 column in excel

i need to refrence A1:A5 (which will return {1;2;3;4;5}) and then add B2:B5 to the end of that (which will return {6;7;8;9;10}), so the finished product will look like this {1;2;3;4;5;6;7;8;9;10}.

does anyone have any ideas? thanks

1 answer

  • answered 2018-03-13 20:21 Scott Craner

    This will return the array desired:


    You can test it by doing:


    Which, when confirmed with Ctrl-Shift-Enter instead of Enter when exiting edit mode, will return the value in B2.

    enter image description here