removing empty cells

[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

 

[Jambruins]

bum

 

[Frank Kabel]

the values are not numbers, they are three letter words like BOS,
SEA,

etc.

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

 

[Dave R.]

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

 

[Gord Dibben]

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

 

[Jambruins]

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