Dynamic ArrayLevel: ExpertAvailable in: Excel 365 / 2021+

VSTACK appends ranges one below another — combine monthly sheets or regional lists without copy-paste.

Syntax

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

Examples

Example 1

=VSTACK(North!A2:E100, South!A2:E100)

One combined list.

Example 2

=VSTACK(Jan:Dec!A2:E100)

3D reference: stacks the same range from every sheet between Jan and Dec.

Power combo

=LET(d, VSTACK(Jan:Dec!A2:E500), FILTER(d, CHOOSECOLS(d,1)<>""))

Stack all months and drop the blank rows.

Related functions

HSTACK · FILTER · CHOOSECOLS

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.