HSTACK
The HSTACK function adjoins arrays horizontally and in sequence to form a larger array.
HSTACK(array)
array: The array to adjoin.
array: Optionally include another array to adjoin.
Notes
You can adjoin multiple arrays using HSTACK.
You can use the spilled range operator “#” to reference an array created by a formula.
Examples |
|---|
Given the following data in cells A1:C4: |
A | B | C | |
|---|---|---|---|
1 | Junior Year | Autumn Term | Spring Term |
2 | GPA | 3.8 | 3.7 |
3 | Senior Year | Autumn Term | Spring Term |
4 | GPA | 3.7 | 3.6 |
=HSTACK(A1:C2, A3:C4) returns the array below: |
A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
5 | Junior Year | Autumn Term | Spring Term | Senior Year | Autumn Term | Spring Term |
6 | GPA | 3.8 | 3.7 | GPA | 3.7 | 3.6 |
See alsoVSTACK