非空白 先上下 後往右 (9009)

 

F2下拉{=INDIRECT(TEXT(RIGHT(SMALL(IF(A$2:D$20<>"",ROW($2:$20)*100+{1,2,3,4}*10001,"1E9"+199),ROW(A1)),4),"!r0c00"),)&""