Skip to content
Google Sheets

VSTACK function in Google Sheets

Appends ranges vertically and in sequence to return a larger array.

=VSTACK(range1; [range2, …])

VSTACK syntax and parameters

Two arguments, one required.

  • range1rangeRequired

    The first range to append.

  • range2rangeRepeating

    [ OPTIONAL ] Additional ranges to add to range1.

VSTACK examples

Formulas you'll actually reuse.

  1. Three monthly sheets stacked into one quarter table:

    =VSTACK(Jan!A2:C50, Feb!A2:C50, Mar!A2:C50)

  2. Keep the header row on top of a de-duplicated table:

    =VSTACK(A1:C1, UNIQUE(A2:C50))

VSTACK in Excel

Same name — your formula ports as-is.

Try VSTACK in the playground

Edit the example — nothing to install.

Preloaded with the VSTACK formula from Example 1 — change anything and watch it respond.

Loading the editor…

VSTACK errors

What they mean — and the fixes.

  • #N/A

    The arrays have different widths — VSTACK pads the narrower one with #N/A; wrap the result in IFERROR(…, "") to blank them.

Related functions

More ways Google Sheets gets this done.