|
楼主 |
发表于 2015-8-31 16:14
|
显示全部楼层
@李建军 是弄成如下这样的
Customer Number Created By Billing Document Sales Document Reference_Document_N Billing Date Billing金额
9791 YCHEN1 '9210441240 60337771 9791-150707-00 2015/8/20 -
126553 GGENG '9210385375 10066382 9210384906 2014/9/2 -
126672 DLI2 '9210443640 180915616 20150819-LSC-TRL 2015/8/27 2,777.00
126553 DLI2 '9210443641 180915625 SPLSC-1508-LI27 2015/8/27 546.00
126676 YCHANG '9210411066 180659961 SPCMD-1409-CH11 2015/5/8 1,122.01
126553 GGENG '9210384906 10066382 9210384906 2014/9/2 -
126646 SLI '9210444144 3287647 GZYT-20150721-2G 2015/8/31 4,386.00
126553 HCAI '9210372948 10066382 9210353335 2014/11/26 -200.00
126590 DLI2 '9210443658 180920826 CDBLRDWX15-31 2015/8/27 5,421.99
126553 LYANG4 '9910056454 3328269 CNQ00141434 2015/8/28 101,970.00
126590 DLI2 '9210443634 180913172 CDBLRDWX15-29 2015/8/27 3,570.00
126646 SLI '9210444119 3330408 GZYT20150820G 2015/8/31 18,682.00
126592 SLI '9210444141 3334327 WAIL-SJKX-150820 2015/8/31 3,630.03
126590 LYANG4 '9910056455 3293559 CNQ00137195 2015/8/28 760.00
126646 SLI '9210444142 3226119 TY-20150610G 2015/8/31 11,704.50
126590 DLI2 '9210443650 180918254 CDBLRDWX15-30 2015/8/27 378.03
不要空行,不要删除任何信息,只要相同的customer code的行不挨着,随便被谁隔开都可以 |
|