同字母依欄取出 再換第二區 (14192)

F2:I10{=SUM(IFERROR(1/COUNTIF(A$2:A2,A$2:A2),))

K2:K23{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(A$2:D$10="","",F$2:I$10/1%%%+{1,2,3,4}*10001+ROW($2:$10)/1%),ROW(A1)),4),"!R0C00"),),"")