同隊名 姓與名結合 取出 (13752)

I2:K9{=IFERROR(INDIRECT(TEXT(SMALL(IF(($A$2:$A$8=I$1)*($B$2:$G$8<>""),ROW($2:$8)/1%+COLUMN($B:$G)),ROW(A1)*2-1),"!R0C00"),),"")&" "&IFERROR(INDIRECT(TEXT(SMALL(IF(($A$2:$A$8=I$1)*($B$2:$G$8<>""),ROW($2:$8)/1%+COLUMN($B:$G)),ROW(A1)*2),"!R0C00"),),"")