Yes, you can ! ! !
Try activating the autofilter in the desired column, and selecting the (NonBlanks)
Then Select the entire column, Copy, and paste where you like, thats all ! !

Saludos

NlCO