If your Excel has VSTACK, stack monthly tables with =VSTACK(Apr[#Data], May[#Data], Jun[#Data]). The result spills into one list, and every table must have the same columns in the same order. VSTACK is available in current Microsoft 365 versions; if you see #NAME?, your version does not have it, so use Power Query instead.
What do you need before using VSTACK?
- Each month's statement stored as an Excel Table, named something like Apr, May and Jun (select the data, press Ctrl+T, and rename it on the Table Design tab).
- The same columns in the same order in every table, for instance Date, Narration, Debit, Credit, Balance.
- Empty cells below and to the right of the formula, since the result spills and a blocked spill shows #SPILL!.
How does the basic formula work?
In an empty cell, say A2 on a sheet called Combined, enter:
=VSTACK(Apr[#Data],May[#Data],Jun[#Data])
The [#Data] part means the table's rows without the heading. To add headings on top, put them first: =VSTACK(Apr[#Headers],Apr[#Data],May[#Data],Jun[#Data]). Excel fills the area below and beside the formula automatically. If the tables have different numbers of columns, VSTACK pads the missing places with #N/A, which is your signal that the layouts disagree.
How do you add a column showing which month each row came from?
HSTACK joins arrays side by side, so you can place a label column to the left of each table before stacking. For each table, build a label array as long as the table, then HSTACK it:
=VSTACK(HSTACK(IF(SEQUENCE(ROWS(Apr[#Data]))>0,"Apr"),Apr[#Data]), HSTACK(IF(SEQUENCE(ROWS(May[#Data]))>0,"May"),May[#Data]))
SEQUENCE(ROWS(Apr[#Data])) produces 1, 2, 3 and so on for each row of April. The IF test turns each number into the text "Apr". HSTACK puts that column beside the April rows, and VSTACK stacks April's block above May's. The formula is long, so write it once, check one month by hand, and then extend it.
What can you do with the stacked list?
- Sort it: =SORT(VSTACK(...),1) puts rows in date order, if the date is the first column and a true date.
- Drop exact repeats: =UNIQUE(VSTACK(...)) removes identical full rows, which can also remove genuine repeat payments, so apply it with care.
- Total from it: refer to the spill with the hash symbol, for example =SUM(INDEX(A2#,,3)) to sum its third column.
How does VSTACK compare with Power Query?
| Point | VSTACK | Power Query |
|---|---|---|
| Setup | One formula, no editor | A few clicks in the editor, once |
| Cleaning steps | You must clean each table first | Remove rows, change types and rename in the same flow |
| New file arrives | Add another table name to the formula | Refresh, if the files sit in a folder |
| Different layouts | Pads with #N/A and misaligns | Matches by heading name |
| Version needed | Current Microsoft 365 | Excel 2016 or later, and Microsoft 365 |
VSTACK suits a handful of tidy tables with identical columns, a quick view, or a formula that must update live as you edit. Power Query suits many files, messy headers, or any case where you want the clean-up recorded.
One practical difference is cleaning. A Power Query flow can remove footer lines and convert text dates before stacking, but with VSTACK those jobs happen in each source table, so tidy them first. If a source table still holds a footer total, it is stacked into the list like any other row.
Does Google Sheets have an equivalent?
Google Sheets stacks with curly braces, using a semicolon between ranges. A separate article covers the Sheets method.
Checks after stacking
- Row count of the spill should equal the sum of the rows in each table: =ROWS(A2#) against =ROWS(Apr[#Data])+ROWS(May[#Data])+ROWS(Jun[#Data]).
- Look at the first and last rows of each month in the list.
- Confirm no column shows #N/A.
For regular monthly statements without formula-building, SpendixAI offers statement imports as PDF, CSV or Excel files, and you review the rows before saving.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


