[算表] 依資料自動新增下一列相同資料
軟體:
excel
版本:
2010
向各位神手求解
公司資料太多太雜,需要自動新增列的資料,但也不是每筆都要新增
所以希望神手幫幫小弟
圖一的紅框處,要自動分成像圖二的樣子
等於是第5列往下新增,圖一紅框有三個,所以C這列就要有三個,其他就以此類推
附上圖一
https://goo.gl/vvZtP5
附上圖二
https://goo.gl/wxhJ8H
先感謝神手
救救小弟
--
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 122.146.47.80
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1490174633.A.D9D.html
→
03/22 18:28, , 1F
03/22 18:28, 1F
→
03/22 18:29, , 2F
03/22 18:29, 2F
→
03/23 11:45, , 3F
03/23 11:45, 3F
→
03/23 11:45, , 4F
03/23 11:45, 4F
→
03/23 11:55, , 5F
03/23 11:55, 5F
→
03/23 12:33, , 6F
03/23 12:33, 6F
→
03/23 17:21, , 7F
03/23 17:21, 7F
→
03/23 17:22, , 8F
03/23 17:22, 8F
→
03/23 17:22, , 9F
03/23 17:22, 9F
→
03/24 00:13, , 10F
03/24 00:13, 10F
→
03/24 08:46, , 11F
03/24 08:46, 11F
→
03/24 09:26, , 12F
03/24 09:26, 12F
→
03/24 09:27, , 13F
03/24 09:27, 13F
→
03/24 09:28, , 14F
03/24 09:28, 14F
→
03/24 10:30, , 15F
03/24 10:30, 15F
→
03/24 10:45, , 16F
03/24 10:45, 16F
→
03/24 10:45, , 17F
03/24 10:45, 17F
→
03/24 10:49, , 18F
03/24 10:49, 18F
→
03/24 10:50, , 19F
03/24 10:50, 19F
→
03/24 11:34, , 20F
03/24 11:34, 20F