è¿ä¸æ¯ç®åçâ转置âã
å设æºæ°æ®å¨Sheet1ï¼A1èµ·ã
1ãå¤å¶Sheet1ç表头å°Sheet2ç第ä¸è¡ââéSheet2çB1~C1ââåå³å¡«å
ï¼å³æï¼å°G1ï¼
2ãå¨Sheet2çA2è¾å
¥
=OFFSET(Sheet1!A2,ROW(A1)*3-3,)
å车并åä¸å¡«å
ï¼
3ãå¨Sheet2çB2è¾å
¥
=OFFSET(Sheet1!$B$2,ROW(B1)*3+COLUMN(A1)/2-3.5,MOD(COLUMN(B1),2))
å车并åå³å¡«å
å°G2ââåéB2~G2ä¸èµ·åä¸å¡«å
ï¼ä¸æï¼ã
温馨提示:答案为网友推荐,仅供参考