How to Remove Rows in Microsoft EXCEL Power Query

The trick to removing rows during a Power Query import/transform process is to use the COLUMN (text) filter feature. Not hard to do once you know the logic. Since Power Query is used where continual data refreshing is likely, you MUST do all the data cleanup within the Power Query screen as those actions will be applied during EVERY Refresh. If you clean things up later (when you build your charts/dashboards/grahps etc) those changes will only work until the next data refresh occurs. My advice is to do as much as you can during the "transform" process while the Power Query screen is active. Saves time/effort in the long run.