Skip to content
ExcelExcel 2024+

VSTACK function in Excel

Appends arrays vertically and in sequence to return a larger array

=VSTACK(array1, [array2], ...)

VSTACK syntax and parameters

Two arguments, one required.

  • array1arrayRequired
  • array2arrayRepeating

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 Google Sheets

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 Excel gets this done.