Stack multiple ranges on top of each other into one combined list — with a single formula.
VSTACK combines two or more ranges by stacking them vertically, one on top of the next. The result spills automatically. No copy-paste, no manual combining, and the output updates when the source ranges change.
VSTACK(array1, [array2], ...)| Argument | What it means |
|---|---|
| array1 required | The first range or array. |
| array2, ... optional | Additional ranges to stack below array1. Up to 254 arrays. |
=VSTACK(A2:A10, C2:C15)Returns all 9 values from A2:A10 followed by all 14 values from C2:C15 — a single 23-row list.
=VSTACK(Sheet1!A2:C50, Sheet2!A2:C30, Sheet3!A2:C20)Consolidates data from three sheets into one range — the same thing that used to require Power Query or manual copy-pasting.
=VSTACK({{"Name","Sales","Region"}}, A2:C100)Pass a literal array (using double curly braces) as the first argument to prepend a custom header row to any dataset.
VSTACK stacks arrays top to bottom (adds more rows). HSTACK stacks arrays left to right (adds more columns). Use VSTACK to combine rows of data; use HSTACK to add columns side by side.
=IFERROR(VSTACK(A2:B10, D2:F15), "")Type it in a live spreadsheet, get instant feedback. No videos, no downloads.
Start practising free →