VSTACK

The VSTACK function adjoins arrays vertically and in sequence to form a larger array.

VSTACK(array, array…)

array: The array to adjoin.

array…: Optionally include another array to adjoin.

Notes

  • You can adjoin multiple arrays using VSTACK.

  • You can use the spilled range operator “#” to reference an array created by a formula.

Examples

Given the following data in cells A1:F2:

A

B

C

D

E

F

1

1/28

LAX

BUR

2/5

JFK

LGA

2

ETA

7:02PM

6:45PM

ETA

1:19PM

3:24PM

=VSTACK(A1:C2, D1:F2) returns the array below:

A

B

C

3

1/28

LAX

BUR

4

ETA

7:02PM

6:45PM

5

2/5

JFK

LGA

6

ETA

1:19PM

3:24PM

See alsoHSTACK
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.