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

28/1

LAX

BUR

2

ETA

7:02PM

6:45PM

3

5/2

JFK

LGA

4

ETA

1:19PM

3:24PM

=HSTACK(A1:C2, A3:C4) returns the array below:

A

B

C

D

E

F

5

28/1

LAX

BUR

5/2

JFK

LGA

6

ETA

7:02PM

6:45PM

ETA

1:19PM

3:24PM

See alsoVSTACK
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ਕੋਈ ਮਦਦ ਮਿਲੀ?
ਅੱਖਰ ਸੀਮਾ: 250
ਵੱਧ ਤੋਂ ਵੱਧ ਅੱਖਰ ਸੀਮਾ 250 ਹੈ
ਫ਼ੀਡਬੈਕ ਲਈ ਤੁਹਾਡਾ ਧੰਨਵਾਦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.