[請益]Excel的自動補齊每列達到固定欄數
軟體:Excel
版本:2013
該怎麼把工作表中每列的欄位補齊
用說的可能講不清楚
大概是這個意思
圖1:
http://ppt.cc/XoNO
圖2:
http://ppt.cc/S2bN
如何把圖一自動排序成圖二的樣子
試過用迴圈copy & paste
然後把偶數行刪除
但是因為列數有十萬多筆效率實在太差
想用相對位置FormulaR1C1 = "=R[1]C[-9]"
再Autofill的寫法
但是又不知道該怎麼做
因為每列要補的欄數不一樣(有一欄跟兩欄的差別)
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 116.118.167.28
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1429025424.A.8CE.html
※ 編輯: shownlin (116.118.167.28), 04/14/2015 23:31:36
→
04/14 23:59, , 1F
04/14 23:59, 1F
→
04/15 00:01, , 2F
04/15 00:01, 2F
→
04/15 00:01, , 3F
04/15 00:01, 3F
推
04/15 01:15, , 4F
04/15 01:15, 4F
→
04/15 01:19, , 5F
04/15 01:19, 5F
推
04/15 01:22, , 6F
04/15 01:22, 6F
→
04/15 01:26, , 7F
04/15 01:26, 7F
→
04/15 01:30, , 8F
04/15 01:30, 8F
→
04/15 07:03, , 9F
04/15 07:03, 9F
→
04/15 07:03, , 10F
04/15 07:03, 10F
→
04/15 07:30, , 11F
04/15 07:30, 11F
→
04/15 07:32, , 12F
04/15 07:32, 12F
→
04/15 07:34, , 13F
04/15 07:34, 13F
→
04/15 07:34, , 14F
04/15 07:34, 14F
→
04/15 07:49, , 15F
04/15 07:49, 15F
→
04/15 10:26, , 16F
04/15 10:26, 16F
→
04/15 10:26, , 17F
04/15 10:26, 17F
→
04/15 11:57, , 18F
04/15 11:57, 18F
→
04/15 15:34, , 19F
04/15 15:34, 19F
→
04/15 15:35, , 20F
04/15 15:35, 20F
成功了 非常感謝你們!我經驗實在不足哈哈...你們好強
※ 編輯: shownlin (116.118.167.28), 04/15/2015 18:30:16