VSTACK appends ranges vertically in sequence. It does not join rows by an ID or automatically align columns by their header names.
Compare the schemas first
Confirm both inputs use the same column order, units, and data types. A second range arranged as Amount, ID will not be rearranged automatically to match an ID, Amount first range.
Choose how to handle headers. Usually the first input includes its header and later inputs exclude theirs, preventing repeated header rows from appearing among records.
Stack a small example
=VSTACK(A1:C10,E2:G10) appends the second three-column block beneath the first. This example uses comma separators; adapt argument separators to the spreadsheet’s locale.
Place the formula in a clear output area. Use equal-width, corresponding schemas for a predictable result, and inspect any unexpected padding or errors rather than treating mismatched widths as a valid combined dataset.
Reconcile the combined population
Compare row counts and known IDs from the end of the first block and start of the second. Check for blank input rows and duplicate records. VSTACK appends; it does not deduplicate or validate business identity.
Keep the original inputs until the combined output is verified. If one source is imported, review its freshness separately from successful stacking. For recurring monthly files, document schema checks before adding another range. A visually complete output can still contain values under the wrong headings if one source changed column order, so verify meaning as well as the total number of resulting columns and rows.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.