Table.Combine
Table function · By Tahir Nas · Examples run in our simulator · Published · Updated
Appends a list of tables, matching columns by name.
When to use it
Use it (Append Queries) to stack tables with the same meaning, such as monthly files or regional exports. Columns are matched by name, so align names and types first; a source column with a different name becomes a separate, mostly-null column.
Syntax
Table.Combine(tables as list, optional columns as any) as tableParameters
- tables
- A list of tables to stack.
Returns
One table with every row.
Example
Table.Combine({#table({"A", "B"}, {{1, 2}}), #table({"A", "C"}, {{3, 4}})})Result
| A | B | C |
|---|---|---|
| 1 | 2 | null |
| 3 | null | 4 |
Example: tag rows with their source
Adding a constant column before combining keeps track of which table each row came from.
Table.Combine({Table.AddColumn(#table({"Qty"}, {{1}}), "Store", each "A", type text), Table.AddColumn(#table({"Qty"}, {{2}}), "Store", each "B", type text)})Result
| Qty | Store |
|---|---|
| 1 | A |
| 2 | B |
Both results are produced by the Power Query Exercises simulator, an independent implementation of a documented subset of M, and checked on every build.
Good to know
- Columns missing from a table become null for its rows.
Common mistakes
- Combining tables whose column names differ slightly (Qty vs Quantity).
- Types differing between sources, which leaves the combined column untyped.
The matching command in Excel
- Excel for Windows
- Home > Append Queries
- What you see
- Two tables or three or more are stacked, with columns matched by name.
Paths are for the Power Query editor in Excel for Microsoft 365, checked against Microsoft's documentation on 8 November 2026: Append queries (Microsoft Learn).
Exercises that use Table.Combine
- beginner~6 minPro
Stack two months of orders (kite shop)
Append February's orders below January's to get one table.
- intermediate~9 minPro
Append store and web sales with different column names (bookshop)
Align WebSales column names to StoreSales before appending, and see where nulls come from.
- beginner~7 minPro
Append three store tables and label each row's store (kite shop)
Each store sends its own orders table. Stack all three and add a Store column saying where each row came from.
- intermediate~8 minPro
Append tables whose columns differ in order and set (kite shop)
Web orders have a Discount column, phone orders a Channel column, and their columns are in different orders. Append by name.
- intermediate~7 minPro
Append two exports that overlap (kite shop)
Two exports cover overlapping weeks, so some orders appear in both, identical. Append them and keep each order once.
- intermediate~8 minPro
Align column types before appending (bookshop)
Shop sales come from a CSV (Amount is text); online sales come from a table (Amount is a number). Make Amount numeric for both.
Learn more
- Append tables and align their columns lesson
- Merge vs append in Power Query: which one do you need? guide
- Combine monthly files into one table with Power Query guide
- Compare two snapshots: new, removed and changed rows guide
Related functions
Official documentation: Table.Combine on Microsoft Learn.