Release notes
Semi-Annual Enterprise Channel
Semi-Annual Enterprise Channel (Preview)
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.
Example 1
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) |
Example 2
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) |
Example 3
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) |