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 1alpha bravo charlie alpha 2delta echo foxtrot bravo 3golf hotel india charlie 4juliet kilo lima delta 5echo 6foxtrot 7golf 8hotel 9india 10juliet 11kilo 12lima
Bookmarks