经典案例1-不规范的销售数据快速高效地整理成标准销售清单

微信二维码：ExcelPPTpx销售日期销售区域城市业务员产品型号销量单价2012-03-27东北区大连李力NKA-561411302012-03-02东北区大连丁任LGC-CD2/8240.51502012-06-17东北区大连丁任ZZA-876252.6502012-06-12东北区大连丁任NKA-56139.21302012-02-05东北区大连赵大成NKA-56274.81302012-03-26东北区大连孙卫海NKA-562871302012-02-05东北区大连孙卫海ZJ-W/9533002012-12-29东北区大连浦爱传KJJ-XY3149.41002012-12-05东北区大连杜世文NC-7/2178.64902012-05-23东北区大连孙卫海ZZA-876109502012-06-02东北区大连丁任NKA-562151302012-11-05东北区大连李力NC-7/299.94902012-11-12东北区大连赵大成NC-7/2296.74902012-12-25东北区大连李力DV-3212993602012-08-07东北区大连孙卫海ZZA-876263502012-05-23东北区大连浦爱传LGC-CD2/892.41502012-02-15东北区大连李力DV-32179.63602012-03-23东北区大连涂源在NC-7/262.34902012-03-27东北区大连涂源在NKA-56155.71302012-03-07东北区大连浦爱传LGC-CD2/82791502012-02-24东北区大连涂源在LGC-CD2/8160.21502012-06-24东北区大连浦爱传LGC-CD2/81771502012-04-16东北区大连浦爱传NKA-56871302012-02-17东北区大连孙卫海ZJ-W/9107.83002012-03-19东北区大连涂源在NKA-56183.61302012-10-28东北区大连杜世文NKA-561931302012-07-29东北区大连杜世文KJJ-XY3136.41002012-02-24东北区大连涂源在NC-7/2157.94902012-11-02东北区大连涂源在DV-321276.83602012-12-21东北区大连赵大成DV-32187.43602012-11-06东北区大连李力LGC-CD2/8190.31502012-04-20东北区大连赵大成NC-7/2269.74902012-05-31东北区大连李力LGC-CD2/852.61502012-03-29东北区大连涂源在ZZA-876148502012-06-28东北区大连李力NKA-56199.31302012-07-23东北区大连孙卫海DV-321183.23602012-02-06东北区大连涂源在NC-7/2534902012-01-13东北区大连涂源在DV-321683602012-05-02东北区大连涂源在KJJ-XY32861002012-04-07东北区大连涂源在NC-7/270.74902012-04-13东北区大连杜世文KJJ-XY3231.81002012-02-02东北区大连孙卫海NKA-56146.31302012-12-16东北区大连涂源在ZJ-W/9156.43002012-09-28东北区大连赵大成LGC-CD2/81261502012-05-27东北区大连李力KJJ-XY3224.41002012-04-21东北区大连李力NC-7/2134.14902012-06-11东北区大连孙卫海NKA-5659.31302012-09-27东北区大连李力LGC-CD2/8268.81502012-05-21东北区大连浦爱传ZJ-W/9149.43002012-10-15东北区大连孙卫海DV-321603602012-02-06东北区大连赵大成KJJ-XY3258.91002012-05-27东北区大连丁任DV-321209.43602012-01-14东北区大连浦爱传NKA-562661302012-07-03东北区大连孙卫海LGC-CD2/8273.21502012-02-20东北区大连孙卫海ZZA-876108502012-07-15东北区大连丁任KJJ-XY3108.61002012-11-13东北区大连浦爱传ZJ-W/92683002012-07-29东北区大连杜世文ZZA-876170.2502012-01-21东北区大连李力NC-7/21944902012-06-10东北区哈尔滨杜世文ZZA-876147.2502012-12-22东北区哈尔滨孙卫海ZJ-W/9124.23002012-01-29东北区哈尔滨李力NC-7/2254.94902012-04-11东北区哈尔滨浦爱传ZZA-876218502012-02-02东北区哈尔滨李力NC-7/22294902012-01-25东北区哈尔滨赵大成ZZA-876269.4502012-06-11东北区哈尔滨李力ZJ-W/9255.53002012-12-22东北区哈尔滨孙卫海ZJ-W/92953002012-02-19东北区哈尔滨浦爱传KJJ-XY3137.41002012-11-21东北区哈尔滨杜世文LGC-CD2/8571502012-01-02东北区哈尔滨杜世文KJJ-XY3131.71002012-09-03东北区哈尔滨李力DV-321713602012-11-11东北区哈尔滨丁任ZZA-876242.6502012-06-05东北区哈尔滨孙卫海LGC-CD2/899.41502012-12-31东北区哈尔滨赵大成LGC-CD2/8178.91502012-04-24东北区哈尔滨涂源在ZJ-W/9157.53002012-05-30东北区哈尔滨孙卫海ZZA-87650.4502012-08-12东北区哈尔滨李力NC-7/2149.84902012-04-10东北区哈尔滨涂源在NC-7/2220.84902012-02-26东北区哈尔滨赵大成NC-7/2674902012-03-08东北区哈尔滨涂源在ZZA-876198.1502012-02-07东北区哈尔滨赵大成NKA-561751302012-08-12东北区哈尔滨赵大成DV-3211713602012-02-11东北区哈尔滨李力ZJ-W/91813002012-12-02东北区哈尔滨李力LGC-CD2/8521502012-03-30东北区哈尔滨丁任NKA-56227.91302012-03-06东北区哈尔滨赵大成ZZA-876296.1502012-03-09东北区哈尔滨孙卫海LGC-CD2/867.11502012-04-22东北区哈尔滨涂源在NKA-56218.31302012-06-19东北区哈尔滨丁任ZZA-87662502012-12-09东北区哈尔滨赵大成DV-321118.93602012-09-19东北区哈尔滨浦爱传NKA-56130.81302012-06-04东北区哈尔滨李力ZJ-W/9683002012-03-03东北区哈尔滨丁任DV-3212023602012-01-14东北区哈尔滨李力ZZA-87688502012-01-20东北区哈尔滨杜世文NKA-5651.41302012-06-12东北区哈尔滨李力LGC-CD2/8106.41502012-04-09东北区哈尔滨浦爱传KJJ-XY31021002012-07-19东北区哈尔滨丁任DV-321180.83602012-01-30东北区哈尔滨丁任LGC-CD2/81031502012-04-29东北区哈尔滨涂源在KJJ-XY3169.41002012-07-21东北区哈尔滨孙卫海KJJ-XY3991002012-06-13东北区哈尔滨杜世文DV-321248.73602012-09-12东北区哈尔滨赵大成LGC-CD2/8190.61502012-12-21东北区哈尔滨浦爱传ZZA-876267502012-06-21东北区哈尔滨孙卫海LGC-CD2/8249.31502012-04-06东北区哈尔滨孙卫海LGC-CD2/8246.21502012-08-01东北区哈尔滨孙卫海ZJ-W/92253002012-10-01东北区哈尔滨杜世文ZZA-876110.9502012-04-14东北区哈尔滨赵大成NKA-56244.41302012-04-21东北区哈尔滨涂源在NKA-56138.21302012-09-03东北区哈尔滨李力NKA-56285.71302012-05-29东北区哈尔滨李力LGC-CD2/82321502012-11-18东北区吉林孙卫海KJJ-XY359.91002012-07-06东北区吉林涂源在ZJ-W/977.83002012-03-21东北区吉林孙卫海LGC-CD2/8161.51502012-09-01东北区吉林李力DV-3212533602012-01-20东北区吉林浦爱传NKA-56160.61302012-07-25东北区吉林丁任NKA-56294.21302012-01-31东北区吉林李力KJJ-XY32301002012-02-15东北区吉林赵大成LGC-CD2/8139.41502012-08-03东北区吉林赵大成LGC-CD2/8144.41502012-05-10东北区吉林丁任NKA-56277.31302012-06-02东北区吉林丁任DV-321160.53602012-06-03东北区吉林涂源在ZZA-876122.2502012-04-23东北区吉林丁任KJJ-XY32281002012-03-16东北区吉林赵大成ZZA-876111.4502012-02-14东北区吉林赵大成NKA-562271302012-03-18东北区吉林涂源在KJJ-XY31561002012-04-23东北区吉林孙卫海ZJ-W/9119.53002012-03-10东北区吉林浦爱传NC-7/21914902012-02-24东北区吉林赵大成NC-7/22384902012-12-21东北区吉林赵大成LGC-CD2/8225.31502012-03-13东北区吉林杜世文NKA-561731302012-05-27东北区吉林李力DV-321282.13602012-01-26东北区吉林赵大成ZZA-876275502012-12-21东北区吉林杜世文KJJ-XY3233.71002012-09-19东北区吉林涂源在LGC-CD2/81931502012-04-12东北区吉林丁任DV-321107.73602012-02-27东北区吉林浦爱传ZJ-W/91013002012-04-07东北区吉林涂源在LGC-CD2/8139.21502012-10-07东北区吉林杜世文KJJ-XY31711002012-03-14东北区吉林浦爱传ZJ-W/9197.93002012-05-04东北区吉林孙卫海LGC-CD2/8711502012-05-01东北区吉林杜世文ZJ-W/9238.93002012-12-26东北区吉林赵大成KJJ-XY3286.51002012-06-04东北区吉林丁任KJJ-XY32061002012-05-10东北区吉林孙卫海KJJ-XY3217.71002012-07-24东北区吉林李力NC-7/282.24902012-03-20东北区吉林浦爱传ZZA-876174502012-07-13东北区吉林丁任ZZA-87675.6502012-10-05东北区吉林孙卫海KJJ-XY31791002012-04-18东北区吉林浦爱传LGC-CD2/8240.21502012-02-04东北区吉林赵大成NKA-562931302012-11-08东北区吉林李力NKA-561271302012-07-10东北区吉林李力LGC-CD2/82211502012-02-06东北区吉林孙卫海DV-321168.53602012