If you spend lots of time deleting unnecessary rows manually, you will benefit from using the Data Filter to clean up data.
When your data looks like this and you are about to spend a few hours manually working through it to keep the red blocks below, consider using the data filter.
Below you can see that after using the data filter, your data looks much cleaner.
To see the full course contents click here.