Quote:
Originally Posted by PrettyPenelope
I would try making a copy of the sheet, and save it under another name so it doesn't affect the original. Then do a sort according to whatever column you want, so that all the lines with actual words/numbers will appear together at the top, and the blank lines below. Hope that helps.
|
Create a reference column with ascending numbers to resort your data by once you've deleted the blanks. Otherwise when you sort your data column it'll put your sequence out of order.