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