Compress a column

H

Harrymo

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
 
R

Ron Coderre

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
 
P

Pete

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
 
Top