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


"datamanipulator" wrote:

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.