K
kippers
Hi,
I have a spreadsheet with nearly 20,000 rows and around 20 columns- every so
often a blank cell appears (it is always in the 2nd column) - I want to
delete the entire row on which this blank cell is placed. This happens
roughly every 10-15 rows so it would be far too time consuming to go through
20k rows manually- can anyone give me a quick and easy way of deleting these
rows?
Any help gratefully appreciated!
cheers
I have a spreadsheet with nearly 20,000 rows and around 20 columns- every so
often a blank cell appears (it is always in the 2nd column) - I want to
delete the entire row on which this blank cell is placed. This happens
roughly every 10-15 rows so it would be far too time consuming to go through
20k rows manually- can anyone give me a quick and easy way of deleting these
rows?
Any help gratefully appreciated!
cheers