getting rid of blanks

[thislibrarian]

Is there a way to automatically remove blanks from my colums of text data. I
want to remove the blank cells and move the others up without having to
select the cells, then delete and answer the question Shift Cells Up?

Thanks