View Single Post
  #1   Report Post  
rgtest
 
Posts: n/a
Default Can I delete blank rows from excel without selecting them?

I exported data from a Crystal Report into Excel. During the export process
extra fields and and columns were added to the data set. I would like to
delete the blank rows that were inserted between every record from my
spreadsheet.

Is there a way to delete extra rows from a spreadsheet without selecting
each row? For example, could I run a script to delete rows with null values
or space?

Thanks