Power QueryExercises

Table.Skip

Table function · By Tahir Nas · Examples run in our simulator · Published · Updated

Skips the first N rows, or leading rows while a condition holds.

When to use it

Use it to remove banner, title or blank rows above the real data, before promoting headers. A count works when the banner is always the same size; a condition handles banners whose length varies from file to file.

Syntax

Table.Skip(table as table, optional countOrCondition as any) as table

Parameters

countOrCondition
Number of rows, or a condition.

Returns

The remaining rows.

Example

Table.Skip(#table({"C"}, {{"Report"}, {""}, {"Data"}}), 2)

Result

C
Data

Example: skip until the header row

A condition keeps skipping while it is true, so the step adapts to any number of banner lines.

Table.Skip(#table({"C"}, {{"Report"}, {"Printed today"}, {"Region"}, {"North"}}), each [C] <> "Region")

Result

C
Region
North

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 > Remove Rows > Remove Top Rows
What you see
You enter how many rows to drop from the top.

Paths are for the Power Query editor in Excel for Microsoft 365, checked against Microsoft's documentation on 8 November 2026: Filter a table by row position (Microsoft Learn).

Exercises that use Table.Skip

Learn more

Related functions

Official documentation: Table.Skip on Microsoft Learn.