reformating data- how to delete alternate blank rows quickly

D

datamanipulator

I need a quick way to delete alternate rows or blanks to reformat a mass of
data which originates as a double spaced .txt file and will end up as .mdb
file.
 
L

Lulu Montiel

Don't know if there's a better way, but I use autofilters. Select all blank
rows a delete them
 
P

Peo Sjoblom

If they are truly empty, select the lot, press F5, select special and then
Blanks, Click OK
Then do edit>delete and when prompted select entire row

Before doing anything make a backup copy of your file


--


Regards,


Peo Sjoblom
 
D

datamanipulator

Thanks. I had found a way using Advanced Filter, but will remember your
method for the next time!
 
Top