ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Ãö©ó¸ê®ÆÂà¸m°ÝÃD

Ãö©ó¸ê®ÆÂà¸m°ÝÃD

½Ð°Ý¸ê®Æ¤u§@ªí­nÂà¸m¦Ü¥t¤@­Ó¤u§@ªí¡A°£¤F½Æ»s-¿ï¾Ü©Ê¶K¤W-Âà¸m¥i¥Î¥H¥~¡A¥i§_¥Î¨ç¼Æ³B²z¡A¦]¬°­ì©l¸ê®ÆÀɤ]³£¬O±q¥L³BºI¨ú¥²­n¸ê®Æ³sµ²¹L¨Ó¡A¦]¬°¦³¯S®í»Ý­n¡A©Ò¥H­nÂà¸m¹L¨Ó¤~¥i¥H¦C¦L¡C¦pªþÀÉ Âà¸m±a¤½¦¡.rar (10.39 KB)
julie

¦^´_ 1# julieh96590


    ¥i¥H¨Ï¥ÎTRANSPOSE ¨ç¼Æ¥[¤WCTRL+SHIFT+ENTER
¨Ï¥Î¤èªk½Ð°Ñ¦ÒMicrosoft TRANSPOSE ¨ç¼Æ »¡©ú
https://support.office.com/zh-tw/article/TRANSPOSE-%E5%87%BD%E6%95%B8-ed039415-ed8a-4a81-93e9-4b6dfac76027

TOP

¦^´_ 1# julieh96590
µ²ªG!A1
=OFFSET(¤À¤ë¥÷!$A$1,COLUMN(A:A)-1,ROW(1:1)-1,,)&""
¥k©Ô¨ìK1¡F¦A¤U©Ô¶ñº¡

TOP

¦^´_ 1# julieh96590


   
2017-11-21_171802.png
2017-11-21 17:19

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD