Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank

Question

I'd like to be able to delete an entire row in a Google Spreadsheets if the value entered for say column "C" in that row is 0 or blank. Is there a simple script I could write to accomplish this? Thanks!

Answer 1

I can suggest a simple solution without using a script !!

Lets say you want to delete rows with empty text in column C. Sort the data (Data Menu -> Sort sheet by column C, A->Z) in the sheet w.r.t column C, so all your empty text rows will be available together.

Just select those rows all together and right-click -> delete rows. Then you can re-sort your data according to the column you need. Done.