Spreadsheet: 587964d1535403025-trying-to-condense-daily-shipping-to-semi-weekly-based-on-a-variety-of-shared-locations-shipping-example
Sheet: Data

Shipment Date | Tracking ID | Net Charge Amount | Recipient Name | Recipient Company | Recipient Address Line 1 | Moday Date | Thursday Date | Next Monday Date | New Ship Date | New Shp Date | DOW | Composite Old | Old [NAME] | Composite New | New Unique | Old Charge | New Carge
2018-04-02 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 11415 Main St
2018-04-02 00:00:00 | [PHONE] | 17.86 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-03 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 11415 Main St
2018-04-05 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 11415 Main St
2018-04-09 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-10 00:00:00 | [PHONE] | 17.19 | Aoife [NAME] | Communications Centers | 11415 Main St
2018-04-10 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 11415 Main St
2018-04-10 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-11 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-17 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 11415 Main St
2018-04-17 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-18 00:00:00 | [PHONE] | 17.9 | Aoife [NAME] | Communications Centers | 11415 Main St
2018-04-24 00:00:00 | [PHONE] | 17.99 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-25 00:00:00 | [PHONE] | 17.99 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-27 00:00:00 | [PHONE] | 17.99 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-30 00:00:00 | [PHONE] | 18.03 | [NAME] | Communications Centers | 11415 Main St
2018-04-30 00:00:00 | [PHONE] | 18.03 | Kieron Parra | Communications Centers | 11415 Main St
2018-04-02 00:00:00 | [PHONE] | 19.13 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-03 00:00:00 | [PHONE] | 19.13 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-04 00:00:00 | [PHONE] | 19.13 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-05 00:00:00 | [PHONE] | 19.13 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-12 00:00:00 | [PHONE] | 19.18 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-16 00:00:00 | [PHONE] | 19.18 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-17 00:00:00 | [PHONE] | 19.18 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-18 00:00:00 | [PHONE] | 19.18 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-26 00:00:00 | [PHONE] | 19.27 | [NAME] | Communications Centers | 134 Simpson Rd
2018-04-03 00:00:00 | [PHONE] | 18.86 | [NAME] | Communications Centers | 221 [NAME]
2018-04-05 00:00:00 | [PHONE] | 18.33 | [NAME] | Communications Centers | 221 [NAME]
2018-04-06 00:00:00 | [PHONE] | 13.69 | [NAME] | Communications Centers | 221 [NAME]
2018-04-12 00:00:00 | [PHONE] | 18.37 | [NAME] | Communications Centers | 221 [NAME]
2018-04-13 00:00:00 | [PHONE] | 18.37 | [NAME] | Communications Centers | 221 [NAME]
2018-04-23 00:00:00 | [PHONE] | 18.46 | Lilly-Rose Alvarez | Communications Centers | 221 [NAME]
2018-04-24 00:00:00 | [PHONE] | 20.88 | [NAME] | Communications Centers | 2812 S Denmark St
2018-04-26 00:00:00 | [PHONE] | 20.88 | [NAME] | Communications Centers | 2812 S Denmark St
2018-04-30 00:00:00 | [PHONE] | 20.93 | [NAME] | Communications Centers | 2812 S Denmark St
2018-04-02 00:00:00 | [PHONE] | 18.33 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-03 00:00:00 | [PHONE] | 18.33 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-04 00:00:00 | [PHONE] | 18.33 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-06 00:00:00 | [PHONE] | 18.33 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-09 00:00:00 | [PHONE] | 18.37 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-11 00:00:00 | [PHONE] | 18.37 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-12 00:00:00 | [PHONE] | 18.37 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-16 00:00:00 | [PHONE] | 18.37 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-17 00:00:00 | [PHONE] | 18.37 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-19 00:00:00 | [PHONE] | 18.37 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-23 00:00:00 | [PHONE] | 18.46 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-24 00:00:00 | [PHONE] | 18.46 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-25 00:00:00 | [PHONE] | 18.46 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-26 00:00:00 | [PHONE] | 18.46 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-27 00:00:00 | [PHONE] | 18.46 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-30 00:00:00 | [PHONE] | 18.5 | Corben Farrow | Communications Centers | 3191 Davidson Rd
2018-04-02 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-03 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-03 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-09 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-09 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-11 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-17 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-18 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-18 00:00:00 | [PHONE] | 17.9 | Mila Pearce | Communications Centers | 3300 HIGHWAY 81
2018-04-27 00:00:00 | [PHONE] | 17.99 | [NAME] | Communications Centers | 3300 HIGHWAY 81
2018-04-02 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 4121 Airport Blvd
2018-04-03 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 4121 Airport Blvd
2018-04-05 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 4121 Airport Blvd
2018-04-02 00:00:00 | [PHONE] | 12.71 | Faye Hendricks | Communications Centers | 4402 Saint Agnes Blvd
2018-04-02 00:00:00 | [PHONE] | 12.71 | Evie-Rose O'Moore | Communications Centers | 4402 Saint Agnes Blvd
2018-04-03 00:00:00 | [PHONE] | 12.71 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-05 00:00:00 | [PHONE] | 17.15 | Bentley [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-05 00:00:00 | [PHONE] | 12.71 | Faye Hendricks | Communications Centers | 4402 Saint Agnes Blvd
2018-04-06 00:00:00 | [PHONE] | 12.71 | Faye Hendricks | Communications Centers | 4402 Saint Agnes Blvd
2018-04-06 00:00:00 | [PHONE] | 12.71 | Evie-Rose O'Moore | Communications Centers | 4402 Saint Agnes Blvd
2018-04-09 00:00:00 | [PHONE] | 12.74 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-10 00:00:00 | [PHONE] | 17.9 | Evie-Rose O'Moore | Communications Centers | 4402 Saint Agnes Blvd
2018-04-11 00:00:00 | [PHONE] | 12.74 | Evie-Rose O'Moore | Communications Centers | 4402 Saint Agnes Blvd
2018-04-12 00:00:00 | [PHONE] | 12.74 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-12 00:00:00 | [PHONE] | 12.74 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-17 00:00:00 | [PHONE] | 12.74 | Faye Hendricks | Communications Centers | 4402 Saint Agnes Blvd
2018-04-18 00:00:00 | [PHONE] | 12.74 | Tess Emery | Communications Centers | 4402 Saint Agnes Blvd
2018-04-18 00:00:00 | [PHONE] | 12.74 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-18 00:00:00 | [PHONE] | 12.74 | Faye Hendricks | Communications Centers | 4402 Saint Agnes Blvd
2018-04-18 00:00:00 | [PHONE] | 12.74 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-19 00:00:00 | [PHONE] | 12.74 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-19 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-20 00:00:00 | [PHONE] | 17.19 | [NAME] | Communications Centers | 4402 Saint Agnes Blvd
2018-04-20 00:00:00 | [PHONE] | 12.74 | Faye Hendricks | Communications Centers | 4402 Saint Agnes Blvd
2018-04-24 00:00:00 | [PHONE] | 17.27 | Tess Emery | Communications Centers | 4402 Saint Agnes Blvd
2018-04-27 00:00:00 | [PHONE] | 12.8 | Faye Hendricks | Communications Centers | 4402 Saint Agnes Blvd
2018-04-27 00:00:00 | [PHONE] | 12.8 | Evie-Rose O'Moore | Communications Centers | 4402 Saint Agnes Blvd