Automatically remove empty cells

[kbka]

Hi!

I have a some columns of data where a row is empty every now and then, and would like to remove the empty cells in that particular column...

As an example say I have empty cells in column A:
A1: 123
A2: 456
A3:
A4:
A5: 23
A6: 4488

I then want to move the data up so that

A1: 123
A2: 456
A3: 23
A4: 4488
A5:
A6:


I now I can do this manually but I have 33089 rows of data with small gaps here and there!


Regards,
kbka

[tom1977]

yes You can do this manually
1. select column A
2. press F5 select "special" next "empty cells"
3. delete shift to up

[kbka]

yes You can do this manually
1. select column A
2. press F5 select "special" next "empty cells"
3. delete shift to up

Thank you fir the quick reply.

I got the cells highlighted. I don't quite get what you mean by
3. delete shift to up

Regards,
Kristian

[tom1977]

right click of mouse then choose delete shift to up