轉置 彙整各戶籍 (11654)

F2:F6{=INDEX(B:B,SMALL(IF(COUNTIF(OFFSET(D$2,,,ROW($1:$12)),$D$2:$D$13)=1,ROW($2:$13),99),ROW(A1)))&""

G2:M6{=IFERROR(OFFSET($B$1,SMALL(IF(VLOOKUP($F2,$B:$D,3,)=$D$2:$D$13,ROW($1:$12)),INT(COLUMN(C1)/2)),MOD(COLUMN(C1),2)),"")