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) |