d1=IFERROR(INDEX(A:A,SMALL(INDEX(($B$1:$B$100="")*10^10+ROW($B$1:$B$100),0),ROWS(D$1:D1))),"")
try this and copy across