尾字母與下格頭字母相同 連接聚於一格 (15113)

C2:N7{=IF(COLUMN(A1)>SUM(SMALL(IF(RIGHT($A$1:$A$26)<>LEFT($A$2:$A$27),ROW($2:$27),28),ROW(A1)+{0,1})*{-1,1}),"",RIGHT(INDEX($A:$A,SMALL(IF(RIGHT($A$1:$A$26)<>LEFT($A$2:$A$27),ROW($2:$27)),ROW(A1))+COLUMN(A1)-1),1+(COLUMN(A1)=1))&D2)