Delete Empty Rows --still not working

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have 2 columns of data with 15000 rows. Some of the
rows in the 2 columns are completely empty and I need to
delete the row and move the number up so that there are
no gaps in the column data. e.g.

1111 2321
3123 5556
3124 3344

3244 5566
3332 3344


4645 3353
______________
convert to:
1111 2321
3123 5556
3124 3344
3244 5566
3332 3344
4645 3353

If anyone can help I would really appreciate it.

don
 
What does "not working" mean? What have you tried? If the details are in
another thread, please don't start a new one.

Meanwhile, select the two columns and try:

Edit | Go To | Special | Blanks | OK | Edit | Delete | Entire Row | OK
 
How about using the Autofilter and choosing (NonBlanks)............Data >
Filter > AutoFilter........(NonBlanks)

Vaya con Dios,
Chuck, CABGx3
 
Thank you that worked perfectly


-----Original Message-----
How about using the Autofilter and choosing (NonBlanks)............Data >
Filter > AutoFilter........(NonBlanks)

Vaya con Dios,
Chuck, CABGx3






.
Click to expand...
 
Back
Top