Skipping blank cells in a list to create an uninterrupted list

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!

Thank you guru. An ingenious formula ... I tried it and everything seemed to work perfectly except at the top of my uninterrupted list is a blank cell that I cannot seem to git rid of even thought the formula:=IF(SUMPRODUCT((rngUserInput<>"")*ISERROR(MATCH(rngUserInput,$B$2:B2,0)))<>0,INDEX(rngUserInput,MATCH(TRUE,ISERROR(IF(ISBLANK(rngUserInput),FALSE,MATCH(rngUserInput,$B$2:$B2,0))),0),1),"")
is there ... all the other cells below the first cell work just great.

Thanks for all your help thus far!

(1) In the link I was directed towards: http://www.contextures.com/excelfiles.html#DataVal

it identifies two columns, input and ouput (the output is for the data validation list). The input feeds just fine into the ouput when the user selects unique numbers BUT if the cells in the input column are formulas then for some reason the ouput column includes at least one blank even though the formulas' purpose is to add only unique entries and remove all blanks. I can't figure this out.

(2) My formula for the named range does not seem to work - I continue to get this error message: "The Source currently evaluates to an error. Do you wish to continue?" and clicking OK gives me a list that has no content.

ANY help would be AWESOME! Thanks!!