Power QueryExercises

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 table

Parameters

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

ABC
12null
3null4

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

QtyStore
1A
2B

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

Common mistakes

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

Learn more

Related functions

Official documentation: Table.Combine on Microsoft Learn.