so I have a spreadsheet with name, email and phone number now I'm using another service to verify those emails but the problem is that the software is returning valid emails and now I wanna remove the rows which don't have valid emails how can I achieve that. As the email verifier is only giving me valid emails and I want to remove the rows which don't have valid emails.
Here's an explainer video on what's the issue I'm facing. 
- next, select all the data on Sheet3
- press CTRL C
- and right after that press CTRL SHIFT V