HSTACK function

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

 

Make a Copy

Related functions

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
4505493712329423300
true
Search Help Center
true
true
true
true
true
35
false
false