VSTACK Function in Google Sheets

Combine multiple ranges vertically using the VSTACK function.

VSTACK Function

The VSTACK function in Google Sheets combines multiple ranges vertically into a single array.

Syntax

VSTACK(range1, [range2, …])
  • range1: The first range to combine.
  • range2, … (optional): Additional ranges to combine.

Examples

  1. Basic Vertical Stack

Stack ranges A1:A3 and B1:B3:

=VSTACK(A1:A3, B1:B3)
  1. Multiple Ranges

Combine multiple ranges C1:C3, D1:D3, and E1:E3:

=VSTACK(C1:C3, D1:D3, E1:E3)

Notes

  • Useful for appending data from different sources or sheets.
  • HSTACK: Combine multiple ranges horizontally.
  • ARRAYFORMULA: Apply a formula to a range of cells.