You can use this array* formula in cell B2:
=IFERROR(INDEX($A:$A,SMALL(IF($A$2:$A$12<>"",ROW($A$2:$A$12)),ROWS($1:1))),"")
then copy down.
*Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual < Enter >.
Hope this helps.
Pete
Bookmarks