同家族彙整同一行 (13507)

H2:M6{=IFERROR(IF(COLUMN(A1)>INDEX(FREQUENCY(ROW($2:$10),IF(RIGHT($D$2:$D$10,2)="户主",ROW($1:$9))),ROW(A2))*2,"",OFFSET($B$1,SMALL(IF(RIGHT($D$2:$D$10,2)="户主",ROW($1:$9)),ROW(A1))+INT((COLUMN(A1)-1)/2),MOD(COLUMN(B1),2))),"")