Remove blank lines between records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was sent an Excel SS with a data record on one line, followed by two blank
lines, followed by a second data record, followed by two blank lines, etc.
Headers are on line 1, data in A2-K2, lines 3 & 4 blank, then a second record
in A5-K5, lines 6 & 7 blank, third record in A8-K8, etc. and repeating down
to line 1594, which has the last record A1594-K1594.
How can I remove the blank records in this SS?
 
Please disregard this post. I used Data>Filter>Autofilter and filtered for
nonblanks. Then highlighted/copied the data to a new sheet.
 
You must log in or register to reply here.

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

Fields in a record are on the next line 4
Data Entry - Write to next cell 3
Record data on two lines 2
Write record from Form to new row in spreadsheet 1
Adding Blank Lines to a Report 0
Insert Row 2
White Space/Blank LInes 2
Record information is on two lines 1

Back
Top