Support
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Windows: 2208 (Build 15601)
Mac: 16.65 (Build 220911)
Web: introduced 15-Sep-2022
iOS: 2.65 (Build 220905)
Android: 16.0.15629

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)

### 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.