1
00:00:00,080 --> 00:00:03,931
January and February each contain three fictional orders, but the team

2
00:00:03,931 --> 00:00:08,132
needs one six-row list without a second header in the middle.

3
00:00:08,132 --> 00:00:11,983
We will append data rows with VSTACK and verify every order

4
00:00:11,983 --> 00:00:13,384
ID and the total.

5
00:00:13,384 --> 00:00:17,585
This is a same-file workflow, so it does not import from

6
00:00:17,585 --> 00:00:19,685
another spreadsheet or change source records.

7
00:00:20,285 --> 00:00:23,935
Create the January and February tabs from the practice card.

8
00:00:23,935 --> 00:00:27,950
Both use Order ID, Date, and Amount USD in columns A

9
00:00:27,950 --> 00:00:31,235
through C, with only three filled data rows each.

10
00:00:31,235 --> 00:00:34,520
Read the first and last IDs in each tab.

11
00:00:34,520 --> 00:00:38,535
The source ranges must have matching widths before VSTACK can place

12
00:00:38,535 --> 00:00:40,360
them underneath one another cleanly.

13
00:00:40,960 --> 00:00:45,093
Add a Master tab and type the three column headings into

14
00:00:45,093 --> 00:00:46,596
A1 through C1 once.

15
00:00:46,596 --> 00:00:50,353
Leave A2 through C7 empty for the formula's spill.

16
00:00:50,353 --> 00:00:54,485
Do not include either source header row in the VSTACK arguments;

17
00:00:54,485 --> 00:00:58,994
using A1:C4 would insert a second header between the monthly blocks.

18
00:00:58,994 --> 00:01:03,127
A blocked destination cell can prevent the array result from expanding.

19
00:01:03,727 --> 00:01:07,504
Select Master A2 and enter the exact formula shown.

20
00:01:07,504 --> 00:01:11,281
VSTACK appends January A2:C4 above February A2:C4.

21
00:01:11,281 --> 00:01:17,156
Google documents that it returns a larger array in the order of its arguments.

22
00:01:17,156 --> 00:01:21,353
These are intentionally bounded ranges, because open-ended columns would

23
00:01:21,353 --> 00:01:24,711
include blank rows that complicate this beginner example.

24
00:01:24,711 --> 00:01:28,907
The formula should spill into six rows and three columns.

25
00:01:29,507 --> 00:01:34,425
In Master, read the six IDs from top to bottom: J-101,

26
00:01:34,425 --> 00:01:38,932
J-102, J-103, F-201, F-202, and F-203.

27
00:01:38,932 --> 00:01:43,850
Confirm that each date and amount still sits beside its original ID.

28
00:01:43,850 --> 00:01:47,947
The February rows must begin directly after the January rows.

29
00:01:47,947 --> 00:01:52,455
If you see a repeated header or blank block, revisit the

30
00:01:52,455 --> 00:01:55,733
referenced row numbers before doing any downstream analysis.

31
00:01:56,333 --> 00:01:59,869
The six fictional amounts add to five hundred twenty dollars.

32
00:01:59,869 --> 00:02:03,759
Compare that independent sum with the Master output; a correct row

33
00:02:03,759 --> 00:02:08,002
count without the correct total could hide a missing or shifted amount.

34
00:02:08,002 --> 00:02:11,892
If you later add an order below row four or a

35
00:02:11,892 --> 00:02:15,428
new month, extend the formula deliberately and repeat the check.

36
00:02:15,428 --> 00:02:20,025
This formula updates values inside its named ranges, but not its range boundaries.