[問題] excel如何將資料合併
我用的是excel2010，請問如何將資料何併，其資料範例如下
原始資料為
Number Item Date Cash
1101 1 20130101 1
1101 1 20130102 2
1101 1 20130104 1
2412 1 20130101 0
2412 1 20130102 2
2412 1 20130104 1
1101 2 20130101 1
1101 2 20130103 2
2412 2 20130102 5
要如何判斷相同Number、Date的將Cash相加，將資料合併
且若是item 1跟2都有，可以顯示 1+2~
希望可顯示的結果如下
Number Item Date Cash
1101 1+2 20130101 2
1101 1 20130102 2
1101 2 20130103 2
1101 1 20130104 1
2412 1 20130101 0
2412 1+2 20130102 7
2412 1 20130104 1
本來打算用手動的...
不過資料量太多筆了，眼睛都快脫窗了...
請教各位版友了，謝謝~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.18.80.16
→
03/25 22:51, , 1F
03/25 22:51, 1F
→
03/25 23:11, , 2F
03/25 23:11, 2F
→
03/25 23:12, , 3F
03/25 23:12, 3F
→
03/25 23:14, , 4F
03/25 23:14, 4F
→
03/25 23:23, , 5F
03/25 23:23, 5F
→
03/25 23:31, , 6F
03/25 23:31, 6F
→
03/25 23:44, , 7F
03/25 23:44, 7F
→
03/25 23:45, , 8F
03/25 23:45, 8F
→
03/26 00:13, , 9F
03/26 00:13, 9F
→
03/26 00:14, , 10F
03/26 00:14, 10F
→
03/26 00:17, , 11F
03/26 00:17, 11F
→
03/26 00:19, , 12F
03/26 00:19, 12F
→
03/26 00:20, , 13F
03/26 00:20, 13F
→
03/26 00:24, , 14F
03/26 00:24, 14F
→
03/26 00:25, , 15F
03/26 00:25, 15F
→
03/26 00:29, , 16F
03/26 00:29, 16F
→
03/26 00:31, , 17F
03/26 00:31, 17F
→
03/26 00:32, , 18F
03/26 00:32, 18F
→
03/26 00:35, , 19F
03/26 00:35, 19F
→
03/26 00:40, , 20F
03/26 00:40, 20F
→
03/26 00:40, , 21F
03/26 00:40, 21F
→
03/26 00:41, , 22F
03/26 00:41, 22F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
