This function appends ranges vertically and in sequence to return a larger array.
Sample Usage
VSTACK(A2:C4; A6:C8)
Syntax
VSTACK(range1; [range2, …])
range1: The first range to append.range2, …: [ OPTIONAL ] Additional ranges to add to range1.
Examples
Simple append operation with VSTACK
Example data:
| 1 | Warehouse A Item | Warehouse A Color | Warehouse A Quantity |
|---|---|---|---|
| 2 | Jeans | Blue | 100 |
| 3 | T-shirt | Pink | 110 |
| 4 | Shorts | Red | 120 |
| 5 | Warehouse B Item | Warehouse B Color | Warehouse B Quantity |
| 6 | Skirt | Pink | 150 |
| 7 | T-shirt | Black | 100 |
| 8 | Shoes | Grey | 50 |
Example: Input this formula in E2: =VSTACK(A2:C4;A6:C8)
Result:
| 1 | Warehouse Item | Warehouse Color | Warehouse Quantity |
|---|---|---|---|
| 2 | Jeans | Blue | 100 |
| 3 | T-shirt | Pink | 110 |
| 4 | Shorts | Red | 120 |
| 5 | Skirt | Pink | 150 |
| 6 | T-shirt | Black | 100 |
| 7 | Shoes | Grey | 50 |