# VSTACK formula generator

> Describe what you need and get a VSTACK formula for Excel and Google Sheets, run on real data before you copy it. Plus 7 tested VSTACK examples.

Source: https://spreadsheetpractice.com/tools/formula-generator/vstack · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

VSTACK stacks ranges on top of each other into one list, such as this month's orders under last month's or one region's reps under another's.

Describe the task at [VSTACK formula generator](https://spreadsheetpractice.com/tools/formula-generator/vstack) and get a VSTACK formula for Excel and Google Sheets, tested on real data.

## Tested VSTACK examples

### Stack two tables on top of each other

`=VSTACK(A2:C5,E2:G6)`

Excel. Result on the sample sheet: 9 rows (I2:K10). [See it and try it](https://spreadsheetpractice.com/formulas/stack-two-tables-on-top-of-each-other)

### Combine two lists without duplicates

`=UNIQUE(VSTACK(A2:A7,C2:C8))`

Excel. Result on the sample sheet: 9 rows (E2:E10). [See it and try it](https://spreadsheetpractice.com/formulas/combine-two-lists-without-duplicates)

### Add headers to a FILTER result

`=VSTACK(A1:C1,FILTER(A2:C10,B2:B10=F1))`

Excel. Result on the sample sheet: 5 rows (E3:G7). [See it and try it](https://spreadsheetpractice.com/formulas/add-headers-to-a-filter-result)

### Combine two ranges in one QUERY

`=QUERY({A1:C6;E2:G6},"select Col1, Col3 order by Col3 desc",1)`

Google Sheets. Result on the sample sheet: 11 rows (I1:J11). [See it and try it](https://spreadsheetpractice.com/formulas/query-two-ranges-at-once)

### Put a header and ARRAYFORMULA in the same cell

`={"Pay";ARRAYFORMULA(IF(A2:A="","",B2:B*C2:C))}`

Google Sheets. Result on the sample sheet: 46 rows (D1:D46). [See it and try it](https://spreadsheetpractice.com/formulas/put-a-header-and-arrayformula-in-one-cell)

### List semi-monthly pay dates (the 15th and last day)

`=SORT(VSTACK(EDATE(B1,SEQUENCE(B2,1,0))+14,EOMONTH(B1,SEQUENCE(B2,1,0))))`

Excel. Result on the sample sheet: 6 rows (D2:D7). [See it and try it](https://spreadsheetpractice.com/formulas/list-semi-monthly-pay-dates)

## Questions

### What does the VSTACK formula generator do?

You describe the task in plain English, and it writes the formula, using VSTACK where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.

### What does VSTACK do?

VSTACK stacks ranges on top of each other into one list, such as this month's orders under last month's or one region's reps under another's.

### Can I learn to write VSTACK formulas myself?

Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the VSTACK function page has a practice exercise.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
