Compress a column

I have a column of numerical values and random empty or null value cells. I want to compress the column so I only retain the numerical values without losing their sequence. Ideally if there was a function like "delete row" where you check for null value cells and delete the appropriate row. Macros won't work because the column sequence changes whenever worksheet is activated

Thank you

Try this:

Select the cells from top of the list to the bottom of the list
Edit>Go To>Click:Special Cells>Select:Blanks....Click [OK]

Edit>Delete>Entire Row

Does that help?

Regards,
Ron

Set up autofilters and select (blanks) from the pull-down list on the
column. Then highlight all the displayed rows which have been filtered
(row indicator shows as blue) and Edit | Delete Row. Select (All) from
the pull-down filter list and you will have what you have asked for.

Hope this helps.

Pete

Hi Pete,

Thank you for your prompt reply. Solved problem


Best Regards,

Harry