deleting empty rows

[Darryl]

Greetings,
I imported some data into my spreadsheet. Now I have several blank rows
scattered throughout all 1500 rows. Is there an easy way to delete the
empty
rows ?

thanks,
Darryl

 

[GVaught]

Open your table and sort ascending on a field that contains a blank, then
highlight all the empty rows by using the far left side of the rows and
dragging down to the end and hit delete. Make sure you only select those
rows that are empty as once you delete they are gone.

 

[Cheryl Fischer]

Just click on a column in an empty row and then click the Sort (A_Z) button.
All of the empty rows should appear together at the top of your table.

 

[Rob Beachy]

Darryl,

You can create a delete query where it looks at the rows and deletes all
rows that have null values