Thread: Copying columns while omitting blank rows

Hi,

I have a column of data that contains some empty cells in it. I would like to simply copy this to another column whilst omitting the blank cells. I hope this is enough explanation, I'm not quite sure how else to describe it.

I've attached an example. Any help would be very much appreciated!

Thanks,

Mouse

Turn on autofilter for the column you want to copy and unselect the blanks option prior to copying it.

Originally Posted by dcgrove

Turn on autofilter for the column you want to copy and unselect the blanks option prior to copying it.

Thank you so much!
Obviously I'm new to excel