So i am working with numerous records (close to 5000) and there are all sorts of data in there. Specific rows contain only percentages. Is there a way to filter out entire rows containing only percentages? I tried going filter like : FILTER > Contains > % ... but alas it didnt work. There are a bunch of blank rows in there too

Any help will be appreciated.