I have been trying to efficently delete blank rows in a spreadsheet that I will need to work regularly (New versions of the spreadsheet every month). I have tried to do it using the go to blanks command (F5, special, select blanks, and then delete rows), but it has unexpected results - sometimes it is deleting actual data. Does anyone know a better way to do this?
Thanks!
I am attaching the spreadsheet I am using as a reference.
Bookmarks