轉置 同户号同行 (11124)

H2:H7{=INDEX(A:A,SMALL(IF(MATCH(A$2:A$10,A:A,)=ROW($2:$10),ROW($2:$10),99),ROW(A1)),)&""

I2:R7{=OFFSET($B$1,SMALL(IF($A$2:$A$10=$H2,ROW($1:$9),99),INT(COLUMN(E1)/5)),MOD(COLUMN(E1),5))&""