close
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:

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
arrow
arrow
    全站熱搜

    gyynimpiamar5 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄