Getting rid of empty cells

J

Jambruins

I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a way
to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with cutting
and pasting. I have a lot of values and empty cells so if there is a formula
that would be a lot quicker than cutting and pasting. Thanks.
 
D

Don Guillett

If the rest of the row is empty, why not just sort by blanks and delete en
masse?
 
Top