Dynamic arrays › VSTACK, DROP106 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeVSTACKDROP

VSTACK + DROP: combine two outlets

Dimas owns a coffee shop with two outlets, in Depok and Bogor. Each outlet records daily sales on its own sheet with identical column headers. For the weekly report, Dimas wants one combined table that updates when either outlet's data changes.

Task

On the Gabungan (combined) sheet, cell A1, write one VSTACK formula that stacks the Depok table (Depok!A1:D5, headers included) and the Bogor table (Bogor!A1:D4) without its header row, using DROP. The headers appear only once. The result spills into A1:D8.

Cells to fillGabungan!A1:D8

Required functionsVSTACKDROP

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
VSTACK(array1, array2, …) stacks several arrays on top of each other, in argument order.
Hint 2
DROP(array, rows) removes a number of rows from the top. The Bogor header is the first 1 row.
Hint 3
Pattern: =VSTACK(Depok!A1:D5, DROP(…, 1)).

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

Gabungan!A1

=VSTACK(Depok!A1:D5,DROP(Bogor!A1:D4,1))

Explanation

=VSTACK(Depok!A1:D5,DROP(Bogor!A1:D4,1)) places the 5 Depok rows (header plus 4 transactions), then the 3 Bogor transactions right below. Without DROP, the Bogor header lands in the middle of the table and breaks totals or filters. Tip: if each outlet's data is stored as an Excel Table, refer to the table names so new rows join the combined table automatically. The partner of VSTACK is HSTACK, which places arrays side by side.

Starting worksheet: Depok
Row	A	B	C	D
1	Date	Outlet	Menu	Cups
2	02/03/2026	Depok	Es kopi susu	48
3	02/03/2026	Depok	Americano	21
4	03/03/2026	Depok	Es kopi susu	52
5	03/03/2026	Depok	Matcha latte	17
6
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result