[請問] EXCEL如何將兩列的資料交錯插入:－20162016韓劇推薦|討論2016韓劇推薦推薦好看的韓劇推薦與韓劇推薦2016韓劇排行榜前十名 , 好看的韓劇推薦 , 2016韓劇收視率

Blogtrottr

批踢踢實業坊 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列的姓名下方請問除了一個一個複製貼上以外，有無更快速的方法，謝謝!! Ａ　　　ＢＡ姓名分數姓名ㄋㄐ 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 Syria
Massacres That Matter - Part 2 - The Media Response On Egypt, Libya And Syria
National 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