move data up when empty cells above

[leecavturbo]

i have a column of info say a1 to a20
but a6 and a14 are empty.
so how can i get a7 to move upto a6 and a15 to a14 leaving the column now sorted with no empty cells a1 to a18.
thx in advance
Lee

 

[Jonmo1]

The answer is in your question...

so how can i get a7 to move upto a6 and a15 to a14 leaving the column now sorted with no empty cells a1 to a18

You could try

Data - Sort - Ascending
But that may not be what you want, it will likely rearrange the data into alphabetic/numeric order (if it wasn't already)..

So maybe try this instead

Highlight the column,
Click Edit - Goto - Special
Select Blanks
Click OK
Right Click Any highlighted Cell
Delete - Shift UP

 

[leecavturbo]

ok that works great for a single column.thx.
but now some data that was in column b thats linked to a is now in the wrong cell. there not linked by formula.
basically i have a list of items a1 to a20. a6 and a14 area empty.
column b1 to b20 has a price of each item but not all item have prices.
so when i moved the data up in a to the empty cells the prices where not
aligned correctly.

 

[Jonmo1]

follow the same steps (edit - goto - special - blanks).

Delete

Instead of Shift UP, select Entire Row