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 tableParameters
- 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
- A condition handles banners of varying length.
Common mistakes
- Skipping a fixed count when the banner length changes.
- Skipping after promoting headers, which removes data.
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
- beginner~7 minFree
Skip the title rows in a report export (consultancy)
The export starts with a report title and a blank line. Skip them, then promote the real headers.
- advanced~14 minPro
Combine two header rows into one (franchise)
A sheet has years on the first row (printed once, over merged cells) and quarters on the second. Build headers like "2026 Q1".
- advanced~12 minPro
Combine files that each start with banner lines (kites)
Every export starts with two banner lines before the header. Write one transform for a file and apply it to all of them.
Learn more
Related functions
Official documentation: Table.Skip on Microsoft Learn.