Generically in cell C2 copied down....

=IFERROR(INDEX(Range,SMALL(IF(Range=criteria,ROW(Range)-MIN(ROW(Range))+1),ROWS(C$2:C2))),"")

confirmed with CTRL+SHIFT+ENTER

so here if your data is in A1:A10 and you want results from B1 down

=IFERROR(INDEX(A$1:A$10,SMALL(IF(A$1:A$10<>"",ROW(A$1:A$10)-ROW(A$1)+1),ROWS(B$1:B1))),"")

confirmed with CTRL+SHIFT+ENTER and copied down

when you run out of data you get blanks