ReferenceFunctionsLookup Functions
VSTACK
VSTACK: Concatenates arrays vertically into a single spilled array.
Summary
VSTACK appends rows from each argument top-to-bottom.
Remarks
- All non-empty range arguments must have the same column count.
- Scalar arguments are treated as 1x1 values.
- Mismatched column counts return
#VALUE!. - Empty inputs are skipped; if all inputs are empty, result is an empty spill.
Examples
Join two 1-row ranges vertically
Grid
| Cell | Value | |
|---|---|---|
Formula
=
Result
Not evaluated yet.
Expected
[[1,10],[2,20]]
Stack scalar values
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
[[5],[9]]
Related functions
FAQ
When does VSTACK return #VALUE!?
VSTACK requires matching column counts across non-empty range arguments; differing widths return #VALUE!.
What happens if all VSTACK inputs are empty ranges?
Empty inputs are skipped, and if every argument is empty the function returns an empty spill.
Runtime metadata
Category
Lookup
Signature
VSTACK(arg1…: Range | Any (Range))This function accepts a repeating argument pattern (min args: 1).
Arity
min 1, max variadic
Arguments
arg1repeating 1Range | Any · Range
Caps
PURE
Source