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.

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

✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/skills-assessment/
?- Test employee Excel skill levels- https://excel-skills-assessment.com/excel-skills-test-for-employment/
?- Improve you Excel Skill Levels- https://online-excel-training.auditexcel.co.za/course-category/skill-based-beg-int-adv/
??- Our main website- https://www.auditexcel.co.za/blogs/

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲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