Try this array formula

=IFERROR(INDIRECT(TEXT(SMALL(IF(A$1:C$10<>"",ROW(A$1:C$10)*10^4+COLUMN(A$1:C$10)),ROWS(D$2:D2)),"R0000C0000"),0),"")

A
B
C
D
1
alpha bravo charlie alpha
2
delta echo foxtrot bravo
3
golf hotel india charlie
4
juliet kilo lima delta
5
echo
6
foxtrot
7
golf
8
hotel
9
india
10
juliet
11
kilo
12
lima