Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
VSTACK
VSTACK appends arrays vertically, placing each subsequent array below the previous one to form a single taller array. All arrays must have the same number of columns, or missing cells are filled with errors. It is an Excel 365 and Google Sheets dynamic array function that spills automatically and is ideal for combining tables from multiple sheets or ranges.
Excel
=VSTACK(A2:B3,A5:B6)Google Sheets
=VSTACK(A2:B3,A5:B6)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2:B3 is the first array — it forms the top portion of the combined result.
- 2A5:B6 is the second array — it is stacked directly below the first array.
- 3Both ranges must have the same column count (2 here); add more arrays as additional arguments.