Hello everybody, I need some help creating a range that skips empty cells.

This is the deal: I have a column range called "Division" in worksheet "A". This range contains empty and non empty cells. I want to create a new column range in worksheet "B" with the same data as worksheet "A", but skipping the empty cells. That is I want a new column range that shows only non-empty cells.

By the way the data is TEXT.

Thanks.