Deleting Empty Rows

[couger77]

Is there any way to delete empty rows within a two column list?

I have about 4200 rows with blank rows inserted randomly that I need t
delete and move the row up

 

[Frank Kabel]

Hi
see your reply in public.excel

P.S.: please don't multipost

 

[mzehr]

Hi Couger!
A simple method is to use Autofilter, then select Blanks
for both columns (This will show only those rows that have
blanks in both), then highlite those rows, and edit delete
rows.

HTH

 

[Evan]

I don't understand "select those rows". I was able to
select them with Edit > Go To > Special > Visible Cells
Only. A subsequent RightClick > Delete Row deletes the
blank rows after answering Yes to the odd query, "Delete
entire row?" The header row is also deleted.

I've been looking for something like this for a long
time. For single columns, I've been setting up an index
column and sorting to push the blanks together. A re-sort
on the index column restores the order. Thanks!

Evan Weiner

 

[Lady Layla]

Can I send you the file so you can do it 4200 times for me?


: Right click on the empty row and select 'Delete' This will remove the empty
row and bring the below items up.