取非空值 先上下後左右 (10735)

 

 D2{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(A$2:B$9>0,ROW($2:$9)/1%+{1,2}*10001),ROW(A1)),4),"!r0c00"),),"")