彙整同戶長 且插入戶長行 (14835)

E2{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(COUNTIF(E$1:E1,B$2:C$11)=0,MATCH(C$2:C$11,C:C,)*10^6+{1,0}*10^4+ROW($2:$11)/1%+{2,3}),1),4),"!R0C00"),),"")

F2=IFERROR(VLOOKUP(E2,B:C,2,),E2)