Appends arrays vertically and in sequence to return a larger array.

Syntax

=VSTACK(array1,[array2],...)

The VSTACK function syntax has the following argument:

array    The arrays to append.

Remarks

VSTACK returns the array formed by appending each of the array arguments in a row-wise fashion. The resulting array will be the following dimensions:

  • Rows: the combined count of all the rows from each of the array arguments.

  • Columns: The maximum of the column count from each of the array arguments.

Errors

If an array has fewer columns than the maximum width of the selected arrays, Excel returns a #N/A error in the additional columns. Use VSTACK inside the IFERROR function to replace #N/A with the value of your choice.

Examples

Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

Vertically appends two simple arrays in sequence so that the results are one array.

Data

A

B

C

AA

BB

CC

D

E

F

DD

EE

FF

Formula

=VSTACK(A2:C3,E2:G3)

Vertically appends three arrays in sequence so that the results are one array of two columns and six rows.

Data

1

2

A

B

X

Y

3

4

C

D

5

6

Formulas

=VSTACK(A2:B4,C2:D3,E2:F2)

Vertically appends three arrays in sequence so that the results are one array of three columns and six rows with a #N/A error to fill in empty array elements.

Data

1

2

A

B

C

#VALUE!

3

4

D

E

F

5

6

Formulas

=VSTACK(A2:B4,C2:E3,F2)

See Also

Guidelines and examples of array formulas

HSTACK function

CHOOSEROWS function

CHOOSECOLS function

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.