轉置 題目改橫式 (12434)

D2:I6{=IFERROR(IF((C2="")*(COLUMN(A1)>1),"",T(OFFSET($B$1,SMALL(IF(ISNUMBER(FIND("題",$B$2:$B$20))*($B$3:$B$21="A"),ROW($1:$19)),ROW(A1))+COLUMN(A1)-1,))&""),"")