Remove rows based on condition in Excel's Power Query

How you can use the various remove row tools in Excel's Power Query including using the filter options (which aren't like normal Excel- using a filter actually means delete/ keep certain rows) to clean up a list of data to be left with only the rows that are important.

------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Remove unnecessary rows in Excel's Power Query
00:27 Removing rows in normal Excel
00:37 Get the report into PowerQuery
00:45 Reducing rows in Power Query
00:58 Remove first 2 rows from the top of the list (or from bottom or alternate rows)
01:46 Removing every alternate row (every 2nd, 5th etc)
02:15 Make a row the headings in Power Query
03:04 Using filters in Power Query to specify which criteria results in keeping/ deleting a row
04:26 Power Query- remove rows versus keep rows buttons
04:50 Other remove/ keep row options (duplicates, blank rows, errors)
05:15 Load the list with rows removed back into Excel

[snowylau]

Thank you! so essentially filtering out what I don't want is the same as "filtering and then deleting" in power query, as the end result will be the same. Thank you!

[Azam_Pakistan]

Great. But dont you think that this filering can be used by just convertiing data to table and then using filter without power query?

[syrophenikan]

I would set the "Date" column to a 'Date' data type, then remove the errors from that column and filter out the nulls.

[briantugbo]

Dude, I thought I was listening to a children's story book. I like the content but man, you need some energy in your voice to maintain attention in your videos

[baselabuobeid]

this is manual work and not based on condition ...