You can filter this table in place.
1) Click on row 2 and activate the DATA > FILTER > AUTOFILTER.
2) Click on row E's drop down and select CUSTOM
3) Use Greater than - zero
This give you the appearance of your Wanted.jpg without having to delete anything.
If you want to actually delete them, then:
1) Click on row 2 and activate the DATA > FILTER > AUTOFILTER.
2) Click on row E's drop down and select ZERO (this will show all rows with zero)
3) Highlight all the visible rows and delete them
4) Turn off the AUTOFILTER and the remaining rows will reappear just like your Wanted.jpg
Bookmarks