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

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