Calling all gurus!

Purpose: a drop-down box with no blanks between selections

Detail: I am trying to create an uninterrupted (no blank cells) list based on a list with intermittent blank cells.

Question: What formula (no VBA please) could I use to grab in sequence, data, without grabbing the blank cells?

Example:

(1) List (this list will dynamically change based on previous selections)
Apples
Oranges

Bananas

Cherries
Strawberries

Honey Dew

(2) I want it to read:
Apples
Oranges
Bananas
Cherries
Strawberries
Honey Dew

So that I can link this list to a drop-down for a seamless list.

Hope this helps - let me know if you need more details! Thanks!