區域數據轉置 以空白隔開 (13453)

C2:F6{=IF((COLUMN(A1)>1)*(B2=""),"",T(OFFSET($A$1,SMALL(IF(($A$1:$A15="")*($A$2:$A16<>"")+(ROW($1:15)=1),ROW($1:15),99),ROW(A1))+COLUMN(A1)-1,))&"")