reformating data- how to delete alternate blank rows quickly

  • Thread starter Thread starter datamanipulator
  • Start date Start date
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.
 
Don't know if there's a better way, but I use autofilters. Select all blank
rows a delete them
 
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
 
Thanks. I had found a way using Advanced Filter, but will remember your
method for the next time!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting blank rows 4
How do I delete blank rows (rows alternate data, blank, data, etc 2
How to delete alternating BLANK rows in .xls file all @ once? 3
Deleting Multiple Blank Rows 6
Deleting Blank Rows. 3
Deleting 63,886 Blank Rows Under My Data 15
Delete Blank Rows 9
Drag text file to Excel -- stopped working 5

Back
Top