Excel 365 + Google Sheets · VSTACK

Stack lists on top of each other

Stacks several ranges into one list that updates by itself.

The formula

=VSTACK(A2:A3, B2:B3)

What each part means

A2:A3First list
B2:B3Goes underneath

Example

Before

	A	B	C
1	Team A	Team B	All
2	Laura	Priya
3	João	Tom
4
5

After

	A	B	C
1	Team A	Team B	All
2	Laura	Priya	Laura
3	João	Tom	João
4			Priya
5			Tom

Step by step

Click cell C2.
Type the formula: =VSTACK(A2:A3, B2:B3)
Press Enter.
The results fill the cells below by themselves (it’s a dynamic array formula). Don’t type anything in them.

Where it works

Excel 365 and Excel 2021 or newer
Google Sheets
Excel for the web (free)

The same formula in other languages

English VSTACK
Español APILARV
Português EMPILHARV

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

FILTER (2 conditions)FILTER with two conditions SORT + UNIQUEA clean A–Z list in one formula SEQUENCENumber any list instantly TAKEAlways show the latest rows COUNTIFSCount with several conditions QuarterAny date into a quarter