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 |