轉置 多維成二維 (11585)

F2:G9{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF($B$2:$D$4<>"",{2;3;4}^(B$1=$C$1)/1%+{2,3,4}*10001),ROW(A1)),4),"!R0C00"),),"")

N2=OFFSET(I$1,,ROW(A3)/3)&""

O2=OFFSET(J$2,MOD(ROW(A1)-1,3),INT((ROW(A1)-1)/3))&""