中英數 分別取出 (13597)

G2:G10{=IFERROR(RIGHT(SMALL(IF(N(+B$2:E$6),ROW(1:5)/1%%+{1,2,3,4}/1%+B$2:E$6),ROW(A1)),2)*1,"")

H2:I10{=INDIRECT(TEXT(SMALL(IF((N(+$B$2:$E$6)=0)*(LENB($B$2:$E$6)=COLUMN(A1)),ROW($2:$6)/1%+{2,3,4,5},9999),ROW(A1)),"!R0C00"),)&""