相鄰重複數為區間 刪除並換欄 (14448)

C3:H9{=IF(C2="","",SUBSTITUTE(OFFSET($A$2,MAX(SMALL(IF(($A$2:$A$19=$A$3:$A$20)*($A$4:$A$21<>$A$3:$A$20)+(ROW($1:$18)=1),ROW($1:$18),99),COLUMN(A1))+($C$2<>C$2)+ROW(A1)-1),)&"",C2,))