fbpx

When and How to Remove Top and Bottom Rows options in Power Query to Remove Top and Bottom Rows in Power Query

Here is a quick post to show the practical scenario when the Remove Top and Bottom Rows options are useful while cleaning up data using Power Query.

Remove Top and Bottom Rows option in Power Query

Remove Top Rows

Often we get CSV files which have tabular data. Sometimes, there is a title, blank rows and some other related but unwanted data just above the useful tabular data. In such cases, we use the Remove Top Rows option.

Remove Bottom Rows

If you get data from web pages (HTLM tables), the header row is repeated at the bottom. This option helps you remove the unwanted row.

Another common issue is that many reports dump data with a grand total at the bottom. Remove Bottom Rows option is also usefu in these cases.

Best Practice

It is quite possible that we focus on the top few rows while cleaning up data. It is equally important to import the data and look at the bottom rows. The bottom part of the data can have many issues which often go unnoticed and may even generate inaccurate results.

Share on linkedin
Share on facebook
Share on twitter

Queries | Comments | Suggestions | Wish list

teams logo

Teamwork Beyond Meetings

Thu 5th Nov – 7pm IST 

Teams Gif

Teamwork Beyond Meetings

Event by Dr. Nitin Paranjape
Thursday, 5th Nov
7 pm IST 

//linkedin insights tag added by nitin on 30 oct 2020