轉置 縱轉橫 (9839)

E3:E7{=IFERROR(INDEX(A:A,SMALL(IF(A$2:A$16<>"",ROW($2:$16)),ROW(A1))),"")

F3:O7{=OFFSET($B$1,SMALL(IF(LOOKUP(ROW($3:$16),ROW($3:$16)/($A$3:$A$16<>""),$A$3:$A$16)=$E3,ROW($2:$15),99),INT(COLUMN(B1)/2)),MOD(COLUMN(B1),2))&""