[算表] excel大量資料如何去重複整理?
軟體:excel
版本:2010
想請教大家~ 有大量資料 如下
1 a b d f
1 a b d f r
1 a b c
1 a
2 a b c d
2 a b x
3 b d w
3 b d w z
3 d w y
在excel 該如何轉換去重複 整理資料為同一個號碼一列 並且將重複的資料都刪去
1 a b c d f r
2 a b c d x
3 b d w y z
謝謝 非常苦惱啊!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.224.87.184
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1435236191.A.CC0.html
→
06/25 23:51, , 1F
06/25 23:51, 1F
→
06/26 08:29, , 2F
06/26 08:29, 2F
→
06/26 08:31, , 3F
06/26 08:31, 3F
→
06/26 08:35, , 4F
06/26 08:35, 4F
→
06/26 08:36, , 5F
06/26 08:36, 5F
→
06/26 08:37, , 6F
06/26 08:37, 6F
→
06/26 08:39, , 7F
06/26 08:39, 7F
→
06/26 08:40, , 8F
06/26 08:40, 8F
→
06/26 08:47, , 9F
06/26 08:47, 9F
→
06/26 08:49, , 10F
06/26 08:49, 10F
→
06/26 09:12, , 11F
06/26 09:12, 11F
→
06/26 09:12, , 12F
06/26 09:12, 12F
→
06/26 09:32, , 13F
06/26 09:32, 13F
→
06/26 09:32, , 14F
06/26 09:32, 14F
→
06/26 09:44, , 15F
06/26 09:44, 15F
→
06/26 09:44, , 16F
06/26 09:44, 16F
推
06/27 02:22, , 17F
06/27 02:22, 17F
→
06/27 09:52, , 18F
06/27 09:52, 18F
推
06/29 01:24, , 19F
06/29 01:24, 19F