轉置 上下數據 (12932)

G2:P6=OFFSET($A$1,MOD(COLUMN(B1),2)+ROW(A1)*2,COLUMN(B1)/2-1)&""

G11:P15=OFFSET($A$1,MOD(SUMPRODUCT(($A$1:$E$2=G$10)*({0;1}+{2,4,6,8,10})),2)+ROW(A1)*2,SUMPRODUCT(($A$1:$E$2=G$10)*({0;1}+{2,4,6,8,10}))/2-1)&""