Excel tutorials

There are multiple ways to merge or combine lists in Excel.

Here we are going to use the function VSTACK to combine 2 small lists.

The VSTACK function combines arrays vertically into a single array.

Start by entering some data in column A and B – they dont have to be the same length.

Now we need to combine them into one list. In C2 – enter the following formula:

=VSTACK(A2:A8;B2:B8)

The first argument is the first list in Column A, the second argument is the second list in Column B.

The final result will be 1 list.