VSTACK
Appends arrays vertically and in sequence to return a larger array.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Combines arrays vertically (stacks them).
Syntax
VSTACK(array1, [array2], ...)
Arguments
array1(array) — First array.array2(array) — Second array.
Examples
Stack Vertically
Combine Range 1 and 2.
FORMULA
=VSTACK(A1:B1, A2:B2)
RESULT
[1, 2; 3, 4]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 1 | 2 |
| 3 | 3 | 4 |