Spreadsheet: 215865d1361526283-this-is-a-tough-one-adding-dates-to-a-line-that-has-no-date-example_sales_report
Sheet: Sheet1

Transaction | Date Sold | Total Sales | Total (Tax Ex) | Sales Tax | Reference | Account # | Register | Customer | Description | On Hand | Cost | Profit | Profit Margin | Original Report
TOTAL |  | 24913.65 | 21353.17 | 3560.48 |  |  |  |  |  |  | 14133.77 | 8069.61 | 0.1197
626540 |  | 38 | 31.67 | 6.33 |  |  |  |  |  |  | 17.33 | 14.34 | 0.1929
626540 | 2013-02-01 10:41:13 | 0 | 0 | 0 | Example One | 10146229 | 18 | Mr [NAME] | Exmaple Product One | -211 | 3.99 | -3.99 | 0
626540 | 2013-02-01 10:41:13 | 0 | 0 | 0 | Example One | 10146229 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
626540 | 2013-02-01 10:41:13 | 38 | 31.6667 | 6.3333 | Example One | 10146229 | 18 | Mr [NAME] | Shipping | 5 | 13.34 | 18.3267 | 0.578737285539699
626547 |  | 35 | 29.17 | 5.83 |  |  |  |  |  |  | 18.44 | 10.73 | 0.1682
626547 | 2013-02-01 10:41:59 | 0 | 0 | 0 | Example One | 10027537 | 18 | Mr [NAME] | Shipping | -211 | 3.99 | -3.99 | 0
626547 | 2013-02-01 10:41:59 | 0 | 0 | 0 | Example One | 10027537 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
626547 | 2013-02-01 10:41:59 | 35 | 29.1667 | 5.8333 | Example One | 10027537 | 18 | Mr [NAME] | Exmaple Product One | 14 | 14.45 | 14.7167 | 0.504571994774863
626586 |  | 41.99 | 34.99 | 7 |  |  |  |  |  |  | 19.99 | 15 | 0.0982
626586 | 2013-02-01 10:52:28 | 3.99 | 3.325 | 0.665 | Example One | 10146230 | 18 | Mr [NAME] | Shipping | -211 | 3.99 | -0.665 | -0.2
626586 | 2013-02-01 10:52:28 | 0 | 0 | 0 | Example One | 10146230 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
626586 | 2013-02-01 10:52:28 | 38 | 31.6667 | 6.3333 | Example One | 10146230 | 18 | Mr [NAME] | Exmaple Product One | 7 | 16 | 15.6667 | 0.494737373960659
626590 |  | 37 | 30.83 | 6.17 |  |  |  |  |  |  | 18.44 | 12.39 | 0.1771
626590 | 2013-02-01 11:01:48 | 0 | 0 | 0 | Example One | 10146232 | 18 | Mr [NAME] | Shipping | -211 | 3.99 | -3.99 | 0
626590 | 2013-02-01 11:01:48 | 0 | 0 | 0 | Example One | 10146232 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
626590 | 2013-02-01 11:01:48 | 37 | 30.8333 | 6.1667 | Example One | 10146232 | 18 | Mr [NAME] | Exmaple Product One | 1 | 14.45 | 16.3833 | 0.531350844703616
626592 |  | 30.98 | 25.82 | 5.16 |  |  |  |  |  |  | 15.39 | 10.43 | 0.0977
626592 | 2013-02-01 11:06:34 | 3.99 | 3.325 | 0.665 | Example One | 154583 | 18 | Mr [NAME] | Shipping | -211 | 3.99 | -0.665 | -0.2
626592 | 2013-02-01 11:06:34 | 26.99 | 22.4917 | 4.4983 | Example One | 154583 | 18 | Mr [NAME] | Exmaple Product One | 0 | 11.4 | 11.0917 | 0.493146360657487
626592 | 2013-02-01 11:06:34 | 0 | 0 | 0 | Example One | 154583 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
Transaction | Date Sold | Total Sales | Total (Tax Ex) | Sales Tax | Reference | Account # | Register | Customer | Description | On Hand | Cost | Profit | Profit Margin | I would like it to…
TOTAL |  | 24913.65 | 21353.17 | 3560.48 |  |  |  |  |  |  | 14133.77 | 8069.61 | 0.1197
626540 |  | 38 | 31.67 | 6.33 |  |  |  |  |  |  | 17.33 | 14.34 | 0.1929
626540 | 2013-02-01 10:41:13 | 0 | 0 | 0 | Example One | 10146229 | 18 | Mr [NAME] | Exmaple Product One | -211 | 3.99 | -3.99 | 0
626540 | 2013-02-01 10:41:13 | 0 | 0 | 0 | Example One | 10146229 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
626540 | 2013-02-01 10:41:13 | 38 | 31.6667 | 6.3333 | Example One | 10146229 | 18 | Mr [NAME] | Shipping | 5 | 13.34 | 18.3267 | 0.578737285539699
626547 |  | 35 | 29.17 | 5.83 |  |  |  |  |  |  | 18.44 | 10.73 | 0.1682
626547 | 2013-02-01 10:41:59 | 0 | 0 | 0 | Example One | 10027537 | 18 | Mr [NAME] | Shipping | -211 | 3.99 | -3.99 | 0
626547 | 2013-02-01 10:41:59 | 0 | 0 | 0 | Example One | 10027537 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
626547 | 2013-02-01 10:41:59 | 35 | 29.1667 | 5.8333 | Example One | 10027537 | 18 | Mr [NAME] | Exmaple Product One | 14 | 14.45 | 14.7167 | 0.504571994774863
626586 |  | 41.99 | 34.99 | 7 |  |  |  |  |  |  | 19.99 | 15 | 0.0982
626586 | 2013-02-01 10:52:28 | 3.99 | 3.325 | 0.665 | Example One | 10146230 | 18 | Mr [NAME] | Shipping | -211 | 3.99 | -0.665 | -0.2
626586 | 2013-02-01 10:52:28 | 0 | 0 | 0 | Example One | 10146230 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
626586 | 2013-02-01 10:52:28 | 38 | 31.6667 | 6.3333 | Example One | 10146230 | 18 | Mr [NAME] | Exmaple Product One | 7 | 16 | 15.6667 | 0.494737373960659
626590 |  | 37 | 30.83 | 6.17 |  |  |  |  |  |  | 18.44 | 12.39 | 0.1771
626590 | 2013-02-01 11:01:48 | 0 | 0 | 0 | Example One | 10146232 | 18 | Mr [NAME] | Shipping | -211 | 3.99 | -3.99 | 0
626590 | 2013-02-01 11:01:48 | 0 | 0 | 0 | Example One | 10146232 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
626590 | 2013-02-01 11:01:48 | 37 | 30.8333 | 6.1667 | Example One | 10146232 | 18 | Mr [NAME] | Exmaple Product One | 1 | 14.45 | 16.3833 | 0.531350844703616
626592 |  | 30.98 | 25.82 | 5.16 |  |  |  |  |  |  | 15.39 | 10.43 | 0.0977
626592 | 2013-02-01 11:06:34 | 3.99 | 3.325 | 0.665 | Example One | 154583 | 18 | Mr [NAME] | Shipping | -211 | 3.99 | -0.665 | -0.2
626592 | 2013-02-01 11:06:34 | 26.99 | 22.4917 | 4.4983 | Example One | 154583 | 18 | Mr [NAME] | Exmaple Product One | 0 | 11.4 | 11.0917 | 0.493146360657487
626592 | 2013-02-01 11:06:34 | 0 | 0 | 0 | Example One | 154583 | 18 | Mr [NAME] | Exmaple Product One | -13 | 0 | 0 | 0
Transaction | Date Sold | Total Sales | Total (Tax Ex) | Sales Tax | Reference | Account # | Register | Customer | Description | On Hand | Cost | Profit | Profit Margin | The result..
TOTAL |  | 24913.65 | 21353.17 | 3560.48 |  |  |  |  |  |  | 14133.77 | 8069.61 | 0.1197
626540 | 2013-02-01 10:41:13 | 38 | 31.67 | 6.33 |  |  |  |  |  |  | 17.33 | 14.34 | 0.1929
626547 | 2013-02-01 10:41:59 | 35 | 29.17 | 5.83 |  |  |  |  |  |  | 18.44 | 10.73 | 0.1682
626586 | 2013-02-01 10:52:28 | 41.99 | 34.99 | 7 |  |  |  |  |  |  | 19.99 | 15 | 0.0982
626590 | 2013-02-01 11:01:48 | 37 | 30.83 | 6.17 |  |  |  |  |  |  | 18.44 | 12.39 | 0.1771
626592 | 2013-02-01 11:06:34 | 30.98 | 25.82 | 5.16 |  |  |  |  |  |  | 15.39 | 10.43 | 0.0977