ExamplesFor You
Home / Excel / VSTACK and HSTACK
✍️ Excel dynamic arrays examples

VSTACK and HSTACK Examples in Excel

Learn practical vstack and hstack examples in excel for modern dynamic Excel reports and spill formulas.

Updated 2026-06-125 practical examplesCopy-ready

What it does

VSTACK combines arrays vertically. HSTACK combines arrays horizontally.

Syntax or pattern

=VSTACK(array1, [array2], ...) / =HSTACK(array1, [array2], ...)
✅

5 practical examples

1

Combine monthly tables

Stack January and February tables.

=VSTACK(Jan,Feb)

Useful for combining similar tables.

2

Add header to output

Stack a header row above filtered data.

=VSTACK({"Product","Sales"},FILTER(Sales[[Product]:[Amount]],Sales[Region]=H2))

Creates a labeled dynamic output.

3

Combine columns side by side

Place names and totals beside each other.

=HSTACK(Products[Name],Products[Sales])

Useful for compact summaries.

4

Stack multiple regions

Combine regional tables into one list.

=VSTACK(East,West,North,South)

Works when columns align.

5

Build a summary table

Join labels and calculated values.

=HSTACK({"Total";"Average"},{SUM(B2:B100);AVERAGE(B2:B100)})

Creates small report blocks.

Common mistakes to avoid

  • Make sure spill ranges have empty space below or beside them.
  • Use Excel Tables where possible for expanding source data.
  • Older Excel versions may not support all dynamic array functions.

Related Excel examples

FILTER Function Examples in ExcelSORT and SORTBY Examples in ExcelUNIQUE Examples in Excel📊 All Excel examples

FAQ

What is a spill formula?

A spill formula returns multiple cells from one formula entered in a single cell.

💡 Useful resources

Here are some ideas for you

Optional resources that may help if you are learning formulas, building reports, or working in spreadsheets often.

  • 📘
    Excel formula books

    Practice formulas with structured examples you can keep beside your desk.

    See ideas
  • ⌨️
    Excel shortcut guides

    Build speed with keyboard shortcuts for selection, formatting and navigation.

    See ideas
  • 🔢
    Numeric keypads

    Helpful if you enter many numbers on a laptop or compact keyboard.

    See ideas
  • 🖥️
    External monitors

    Useful for viewing large worksheets, formulas and reference tables side by side.

    See ideas
  • 📒
    Desk notebooks

    Sketch formula logic, report ideas and table structures before building.

    See ideas
  • 💻
    Laptop stands

    Make long spreadsheet sessions more comfortable and ergonomic.

    See ideas

Some links in this section may be affiliate links. Choose only what is useful for your own work.