依字母次序 往下彙整字母 (13854)

取最多出現次數 D1:I1{=IF(COLUMN(A1)>MAX(COUNTIF($B:$B,$B2:$B16)),"",COLUMN(A1))

D2:I7{=INDEX($B:$B,SMALL(IF(CODE($B$2:$B$16)=SMALL(IF(MATCH($B$2:$B$16,$B:$B,)=ROW($2:$16),CODE($B$2:$B$16),99),ROW(A1)),ROW($2:$16),99),COLUMN(A1)))&""