ããè¡åä¸æ¢æ两ç§æ¹æ³ï¼ä¸æ¯ç®åå¤å¶ï¼äºæ¯ç¨å½æ°ï¼ç¨å½æ°ç好å¤å¨äºåè¾¹æ°æ®åäºï¼åè¾¹è·çåã
ããä¸ãæ¯å¤å¶ï¼éæ©æ§ç²è´´ã转置ï¼
ããäºãæ¯ç¨å½æ°TRANSPOSE()
ãã1ãå½å ¥æ°æ®ï¼
ãã2ãéä¸è¡æ°ä¸è¿ä¸ªåºååæ°ç¸åãåæ°ä¸è¿ä¸ªåºåè¡æ°ç¸åçåºåï¼
ãã3ãå½å ¥å ¬å¼ï¼=TRANSPOSE(A1:D6)ï¼ç¶ååæ¶æä¸ctrl+shift+enterä¸ä¸ªé®ã