提取非空白成一行 (9724)

B19:V19 {=IFERROR(INDIRECT(TEXT(SMALL(IF($B6:$M16<>"",ROW(6:16)/1%+COLUMN($B:$M)),COLUMN(A1)),"!R0C00"),),"")

文字數據且都二位數=MID(PHONETIC($B$6:$M$16),COLUMN(A1)*2-1,2)