Blogtrottr img { border:none } 批踢踢實業坊 ask 板 Want free Kindle ebooks?Sign up to receive the best freebie Kindle ebook deals in your email every day. From our sponsors [請問] EXCEL如何將兩列的資料交錯插入 Oct 17th 2013, 07:12, by KU0 作者KU0 ( ) 站內ask 標題[請問] EXCEL如何將兩列的欄位交錯插入 時間Thu Oct 17 07:12:09 2013 請問有一份EXCEL資料 原本A列為姓名,B列為分數 想讓原本A列下方插入一欄:讓B列的分數直接插入於A列的姓名下方 請問除了一個一個複製貼上以外,有無更快速的方法,謝謝!! A B A 姓名 分數 姓名 ㄋㄐ 40 ◣ 分數 柏油 90 ███◣ ㄋㄐ 鄭公 100 ███◤ 40 瓦哥 30 ◤ 柏油 鄉長 60 90 鄭公 100 瓦哥 30 鄉長 60 -- . ● + . ▂▃▄▃▂ ▂▃▄▂ . + + ◢////|\\\\◣ http://www.badongo.com/file/4088182 -- ▁▂▁▁ ╫█ -- -- _ _ _ _ ▄▄▄▄▄▄▄▄▄▄▄█▇▇▇▆▆▅▄▄▄▃▂▂▁▁▂▃▄▅▅▅▆▇▇███ " . ` . " . ` " . -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 114.39.99.158 推 RockSound:在C欄位依序鍵入SA1,SB1,SA2,SB2依此類推 在將S取代成= 10/17 08:01 This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: Massacres That Matter - Part 1 - 'Responsibility To Protect' In Egypt, Libya And SyriaMassacres That Matter - Part 2 - The Media Response On Egypt, Libya And SyriaNational demonstration: No attack on Syria - Saturday 31 August, 12 noon, Temple Place, London, UK You are receiving this email because you subscribed to this feed at blogtrottr.com. If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions