Spreadsheet: 165486d1341246670-excel-2007-dedupe-concatenate-and-sum-values-all-in-one-go-samplefordedupe
Sheet: Sheet1

Site Name | Start Date | End Date | Amount | Category | Consignments
Site A | 2010-04-26 00:00:00 | 2010-05-02 00:00:00 | 1 | [NAME] | ADS18602GWOM
Site A | 2010-04-26 00:00:00 | 2010-05-02 00:00:00 | 1 | [NAME] | [NAME]
Site A | 2010-04-26 00:00:00 | 2010-05-02 00:00:00 | 10 | Boxes | ADB43802GWBM
Site A | 2010-04-26 00:00:00 | 2010-05-02 00:00:00 | 1 | Boxes | ADB47202GW6M
Site A | 2010-04-26 00:00:00 | 2010-05-02 00:00:00 | 1 | Buckets | AJZ20102GW9M
Site B | 2010-05-10 00:00:00 | 2010-05-16 00:00:00 | 1 | [NAME] | ADB44502GWDM
Site B | 2010-05-10 00:00:00 | 2010-05-16 00:00:00 | 1 | [NAME] | AGS26002GW3M
Site B | 2010-05-10 00:00:00 | 2010-05-16 00:00:00 | 1 | [NAME] | AGS25502H4UM
Site B | 2010-05-10 00:00:00 | 2010-05-16 00:00:00 | 1 | Buckets | NBZ60702H4VM
Site C | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | Boxes | ADQ24202RRKM
Site D | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | [NAME] | AIX01902GIDM
Site D | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AKI58402GIIM
Site D | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | Buckets | ADQ25402GIHM
Site D | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | ADQ25202GI7M
Site D | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | ADQ26302GICM
Site E | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | ADQ22302RMWM
Site E | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | NDG26102NN5M
Site E | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AGB25903X81
Site E | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME]
Site E | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AHR41902NRZM
Site F | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AGS28502HS2M
Site F | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 4 | [NAME] | AGS25602I78M
Site F | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | [NAME]
Site F | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | ADB44702JB5M
Site G | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 3 | Boxes | AIN98202IDTM
Site G | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | ADB44802IPBM
Site G | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AJZ20102JB3M
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 15 | [NAME] | AHP97002GIGM
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 9 | [NAME] | ADQ21802H3TM
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | [NAME] | AHR42302H4AM
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | ADQ26802GI4M
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | AIX01902HI7M
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | AHP97002HHGM
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | ADQ25902GI9M
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AKI58502HHOM
Site H | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | AHR41802HHPM
Site I | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | ADQ23202R4FM
Site I | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | ADQ24602R50M
Site I | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | ADQ22702R9DM
Site I | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 7 | Boxes | ADQ23602R9MM
Site I | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | Buckets | AHR43402RL3M
Site J | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 20 | [NAME] | ADQ22302H4BM
Site J | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | ADQ25402HHHM
Site J | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | [NAME]
Site K | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 6 | Buckets | AGB25903XSU
Site K | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AHF42602NCYM
Site K | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | AHF44102O7OM
Site L | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 3 | Boxes | AHR42702GI2M
Site L | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | ADQ26002GNGM
Site L | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | AHR43002GG6M
Site M | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 7 | Boxes | AHR42802R4JM
Site M | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | AHR42902R4HM
Site M | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AHR43102R4YM
Site N | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AGB27702PQLM
Site N | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | [NAME] | AGL47802N7EM
Site N | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AGB25903X0MM
Site N | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 5 | Boxes | AGB27702P1JM
Site N | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME]
Site N | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | AHR41902OCMM
Site O | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 6 | Buckets | AHR41402RFQM
Site P | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AGB25903X81
Site P | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 3 | Boxes | AGB27702PQLM
Site P | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | EXESRC02NMPM
Site P | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | AHR41902OP2M
Site Q | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | [NAME]
Site Q | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | [NAME]
Site Q | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets
Site Q | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | ADB44702IK3M
Site Q | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | AJZ20302J0WM
Site R | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 6 | Boxes | AJZ20002IDWM
Site R | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AIN98402IPCM
Site R | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | ADB47202JB1M
Site S | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 5 | [NAME] | SRCLSQ03WHCM
Site S | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 7 | [NAME] | [NAME]
Site S | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 5 | Boxes | [NAME]
Site S | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes
Site S | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | AHR41902O2DM
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | AGL47802Q2ZM
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | AGB27702NMZM
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | [NAME] | AGL47802NX7M
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 17 | Buckets | AGB25903Y4BM
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AIW93502NMKM
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | AHR41902OEOM
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 3 | Boxes | AGL47802OOBM
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets
Site T | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | AHF43802O7MM
Site U | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | Boxes | ADQ24202HBIM
Site U | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 5 | Buckets | AHR41002GFXM
Site U | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 7 | Boxes | ADQ23702GFYM
Site U | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 5 | Boxes | AHR43402H4CM
Site U | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | [NAME] | ADQ26802HHIM
Site U | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AHR41702HHRM
Site V | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 2 | Boxes | AHR43002RRQM
Site W | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 5 | [NAME] | ADQ22102RRSM
Site X | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | ADQ21802RMVM
Site Z | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Buckets | [NAME]
Site Z | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes | AGL47802NX7M
Site Z | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 9 | Boxes | [NAME]
Site Z | 2010-05-31 00:00:00 | 2010-06-06 00:00:00 | 1 | Boxes