removing empty cells

  • Thread starter Thread starter Jambruins
  • Start date Start date
J

Jambruins

Cells A1-A5 and A11-A15 have values in them while cells A6-A10 do not.
I would like column C to have all of column A values without the empt
cells in between them. So cells A1-A5 and A11-A15 would be in cell
C1-C10. How can I do this?Thank
 
the values are not numbers, they are three letter words like BOS,
SEA,
etc.
Click to expand...

Hi
if this is just a 'one-time' operation I would use Filer: Goto 'Data -
Filter - Autofiler'. Filter all 'non blanks' and copy these cells to
column C

Frank
 
That's ill-advised. I dont think most people are reading it via the www
forum anyways.
 
One method

Hide the rows with no data.

Select the visible cells.

Edit>Go To>Special>Visible cells>OK

Copy these cells and paste at C1. Note: you will see only the first 5 but
don't worry, the others are there.

Unhide the blank rows.

Gord Dibben Excel MVP
 
I need to do this to 30 sheets so I am looking for something that wil
work when I copy the original data in. Something that does i
automatically instead of having to go into each sheet and copy th
column to another column. Thanks
 
Back
Top