Spreadsheet: 27869d1221583678-vlookup-and-pivot-table-to-raw-cvs-file-via-data-connections-sample-data
Sheet: Sample Data (2)

Master# | Accounts Receivable Number | Customer Name | Market | Item Date | Due Date | Amount
42396 | 42396 | ALPHA.COM CORP | RETL | 2006-03-13 00:00:00 | 2006-03-13 00:00:00 | -5.22
44994 | 44994 | BEST.COM | RETL | 2008-04-08 00:00:00 | 2008-04-08 00:00:00 | -261.48
44994 | 44994 | BEST.COM | RETL | 2008-04-15 00:00:00 | 2008-04-15 00:00:00 | -254.14
44994 | 44994 | BEST.COM | RETL | 2008-04-22 00:00:00 | 2008-04-22 00:00:00 | -164.76
44994 | 44994 | BEST.COM | RETL | 2008-04-30 00:00:00 | 2008-04-30 00:00:00 | -145.76
44994 | 44994 | BEST.COM | RETL | 2008-04-30 00:00:00 | 2008-05-30 00:00:00 | 631.21
44994 | 44994 | BEST.COM | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -325.27
44994 | 44994 | BEST.COM | RETL | 2008-05-08 00:00:00 | 2008-05-08 00:00:00 | -222.99
44994 | 44994 | BEST.COM | RETL | 2008-05-13 00:00:00 | 2008-05-13 00:00:00 | -288.88
44994 | 44994 | BEST.COM | RETL | 2008-06-05 00:00:00 | 2008-06-05 00:00:00 | -233.3
44994 | 44994 | BEST.COM | RETL | 2008-06-17 00:00:00 | 2008-06-17 00:00:00 | -366.04
44994 | 44994 | BEST.COM | RETL | 2008-06-24 00:00:00 | 2008-07-24 00:00:00 | 236.58
44994 | 44994 | BEST.COM | RETL | 2008-07-07 00:00:00 | 2008-07-07 00:00:00 | -233.04
44994 | 44994 | BEST.COM | RETL | 2008-07-14 00:00:00 | 2008-07-14 00:00:00 | -535.95
44994 | 44994 | BEST.COM | RETL | 2008-07-31 00:00:00 | 2008-07-31 00:00:00 | -338.53
44994 | 44994 | BEST.COM | RETL | 2008-08-05 00:00:00 | 2008-08-05 00:00:00 | -566.22
44994 | 44994 | BEST.COM | RETL | 2008-08-07 00:00:00 | 2008-09-06 00:00:00 | 3135
44994 | 44994 | BEST.COM | RETL | 2008-08-20 00:00:00 | 2008-09-19 00:00:00 | 28.34
44994 | 44994 | BEST.COM | RETL | 2008-08-21 00:00:00 | 2008-09-20 00:00:00 | 7.79
44994 | 44994 | BEST.COM | RETL | 2008-09-09 00:00:00 | 2008-09-09 00:00:00 | -4.72
000M0002 | 3301470 | KINYA CO | RETL | 2008-07-29 00:00:00 | 2008-09-27 00:00:00 | 23.7
000M0003 | 70152535 | BLOCKCORP | RETL | 2008-02-27 00:00:00 | 2008-02-27 00:00:00 | -590.98
000M0119 | 1125463 | ROUND CO | RETL | 2007-01-11 00:00:00 | 2007-01-11 00:00:00 | -259.5
000M0119 | 1125463 | ROUND CO | RETL | 2007-01-22 00:00:00 | 2007-01-22 00:00:00 | -222.09
000M0119 | 1125463 | ROUND CO | RETL | 2007-02-09 00:00:00 | 2007-02-09 00:00:00 | -221.56
000M0119 | 1125463 | ROUND CO | RETL | 2007-02-09 00:00:00 | 2007-02-09 00:00:00 | -332.34
000M0119 | 1125463 | ROUND CO | RETL | 2007-02-09 00:00:00 | 2007-02-09 00:00:00 | -332.34
000M0119 | 1125463 | ROUND CO | RETL | 2007-02-09 00:00:00 | 2007-02-09 00:00:00 | -327.81
000M0119 | 1125463 | ROUND CO | RETL | 2007-02-12 00:00:00 | 2007-02-12 00:00:00 | -221.56
000M0119 | 1125463 | ROUND CO | RETL | 2007-02-12 00:00:00 | 2007-02-12 00:00:00 | -334.4
000M0119 | 1125463 | ROUND CO | RETL | 2007-02-12 00:00:00 | 2007-02-12 00:00:00 | -327.81
000M0119 | 1125463 | ROUND CO | RETL | 2007-05-03 00:00:00 | 2007-05-03 00:00:00 | -102.19
000M0119 | 1125463 | ROUND CO | RETL | 2007-05-03 00:00:00 | 2007-05-03 00:00:00 | -564.12
000M0119 | 1125463 | ROUND CO | RETL | 2007-05-11 00:00:00 | 2007-05-11 00:00:00 | -1611.96
000M0119 | 1125463 | ROUND CO | RETL | 2007-12-27 00:00:00 | 2007-12-27 00:00:00 | -717.6
000M0119 | 1125463 | ROUND CO | RETL | 2008-01-04 00:00:00 | 2008-03-04 00:00:00 | 37.1
000M0119 | 1125463 | ROUND CO | RETL | 2008-01-04 00:00:00 | 2008-03-04 00:00:00 | 79.28
000M0119 | 1125463 | ROUND CO | RETL | 2008-02-11 00:00:00 | 2008-04-11 00:00:00 | 79.81
000M0119 | 1125463 | ROUND CO | RETL | 2008-02-11 00:00:00 | 2008-04-11 00:00:00 | 65.34
000M0119 | 1125463 | ROUND CO | RETL | 2008-02-26 00:00:00 | 2008-02-26 00:00:00 | -230.28
000M0119 | 1125463 | ROUND CO | RETL | 2008-02-26 00:00:00 | 2008-02-26 00:00:00 | -54.2
000M0119 | 1125463 | ROUND CO | RETL | 2008-02-26 00:00:00 | 2008-02-26 00:00:00 | -37.26
000M0119 | 1125463 | ROUND CO | RETL | 2008-02-26 00:00:00 | 2008-04-26 00:00:00 | 168.66
000M0119 | 1125463 | ROUND CO | RETL | 2008-02-26 00:00:00 | 2008-04-26 00:00:00 | 90.67
000M0119 | 1125463 | ROUND CO | RETL | 2008-02-26 00:00:00 | 2008-04-26 00:00:00 | 37.95
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -377.88
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -415.91
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -376.56
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -46.12
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -276.46
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -39.27
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -171.01
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -48.69
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -37.15
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -36.25
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -56.99
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -162.06
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-05-06 00:00:00 | -702.35
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 587.2
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 203.24
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 538.77
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 263.91
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 176.03
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 28.5
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 254.74
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 26.42
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 87.18
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 694.43
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 56.85
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 37.41
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 537.01
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 616.59
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 176.07
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 840.87
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 73.88
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 58.02
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 37.19
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 56.14
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 106.58
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 143.44
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 95.02
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 123.22
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 88.96
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 143.94
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 72.28
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 121.55
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 88.96
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 94.52
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 50.04
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 108.11
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 113.23
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 45.48
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 218.95
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 79.84
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 240.55
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 149
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 128.82
000M0119 | 1125463 | ROUND CO | RETL | 2008-05-06 00:00:00 | 2008-07-05 00:00:00 | 250.92