This function appends arrays horizontally and in sequence to return a larger array.
Sample Usage
HSTACK(A1:E2; A3:E4)
Syntax
HSTACK(range1; [range2, …])
range1
: The first range to append.range2, …
: [ OPTIONAL ] Additional ranges to add to range1.
Examples
Simple append operation with HSTACK
Example data:
A |
B |
C |
D |
E |
|
---|---|---|---|---|---|
1 |
Year: 2021 |
Q1 |
Q2 |
Q3 |
Q4 |
2 |
Winner |
Andrew |
Luca |
Robert |
Eric |
3 |
Year: 2022 |
Q1 |
Q2 |
Q3 |
Q4 |
4 |
Winner |
Lola |
Andy |
Mary |
Kate |
Example: Input this formula in A6: =HSTACK(A1:E2; A3:E4)
Result:
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
|
---|---|---|---|---|---|---|---|---|---|---|
6 |
Year: 2021 |
Q1 |
Q2 |
Q3 |
Q4 |
Year: 2022 |
Q1 |
Q2 |
Q3 |
Q4 |
7 |
Winner |
Andrew |
Luca |
Robert |
Eric |
Winner |
Lola |
Andy |
Mary |
Kate |