Spreadsheet: 151906d1335181967-excel-2007-merge-dates-example
Sheet: Sheet1

city_name | [NAME] | [NAME] | merchant_id | deal_title | deal_start | deal_end | deal_status | deal_original_price | deal_special_price | discount | displayed_sales | real_sales | unique_customers | turnover | turnover_per_customer | deal_type | deal_permalink_title | max_participants | end_time_voucher | merchant_name
Oslo | 18651 | 14959 | 5515 | Ã‰n mÃ¥ned Pilatestrening og startpakke [NAME]! | 2010-06-06 00:00:00 | 2010-06-06 23:59:59 | 2 | 1398 | 699 | 50 | 7 | 4 | 4 | 2796 | 699.00 | 1 | pilates_room_rabatt | 9999 | 2012-06-08 23:59:00 | Pilates Room
Oslo | 18746 | 15798 | 5541 | Hele 45 min eksklusiv tannbleking pÃ¥ skjÃ¸nnhetsklinikken Cosmo Beauty | 2010-06-07 00:00:00 | 2010-06-07 23:59:59 | 2 | 3800 | 1140 | 70 | 17 | 14 | 13 | 15960 | 1227.69 | 1 | cosmo_beauty_rabatt | 9999 | 2012-09-07 23:59:00 | Cosmo Beauty
Oslo | 19481 | 14916 | 5722 | All you can eat mongolsk mat pÃ¥ eksklusive restauranten [NAME] | 2010-06-08 00:00:00 | 2010-06-08 23:59:59 | 2 | 169 | 84 | 50 | 111 | 108 | 39 | 9072 | 232.62 | 1 | djengis_khan_rabatt | 9999 | 2011-06-08 23:59:00 | [NAME]
Kristiansand | 18957 | 16267 | 5585 | Ã…rets sommershow i Kristiansand til halv pris | 2010-06-08 00:01:00 | 2010-06-09 23:59:59 | 2 | 350 | 129 | 63 | 7 | 4 | 2 | 516 | 258.00 | 1 | [NAME] | 9999 | 2010-07-31 21:00:00 | [NAME]
Oslo | 18982 | 16202 | 5609 | 1 mÃ¥ned trening dÃ¸gnet rundt [NAME] treningssentre med [NAME] | 2010-06-09 00:00:00 | 2010-06-09 23:59:59 | 2 | 343 | 145 | 58 | 4 | 1 | 1 | 145 | 145.00 | 1 | [NAME] | 9999 | 2011-06-09 23:59:00 | JIMU treningssenterkjede
Oslo | 20262 | 12935 | 4385 |  | 2010-06-09 00:01:00 | 2010-06-09 23:59:59 | 2 | 180 | 90 | 50 | 19 | 16 | 7 | 1440 | 205.71 | 2 | indianhouse_rabatt | 99999 | 2011-06-10 23:59:00 | Indian House
Oslo | 19996 | 16689 | 5838 | Heftig og adrenalinfylt tur med RIB-bÃ¥t i Oslofjorden | 2010-06-10 00:00:00 | 2010-06-10 23:59:59 | 2 | 1000 | 499 | 50 | 10 | 7 | 4 | 3493 | 873.25 | 1 | rib_oslo_rabatt | 53 | 2010-06-13 15:00:00 | RIB Oslo
Oslo | 20454 | 12911 | 4420 |  | 2010-06-10 00:01:00 | 2010-06-10 23:59:59 | 2 | 265 | 130 | 51 | 15 | 11 | 5 | 1430 | 286.00 | 2 | mehfel_rabatt | 99999 | 2011-06-11 23:59:00 | [NAME]
Oslo | 20412 | 16921 | 5913 | Oslos beste is pÃ¥ den italienske restauranten Amundsen & Nobile | 2010-06-11 00:00:00 | 2010-06-11 23:59:59 | 2 | 98 | 49 | 50 | 25 | 22 | 6 | 1078 | 179.67 | 1 | amundsen_nobile_rabatt_oslo | 9999 | 2011-06-12 23:59:00 | Amundsen & Nobile
Oslo | 20879 | 17010 | 5975 | 1 valgfri pizza med 1 drikke [NAME] | 2010-06-12 00:00:00 | 2010-06-12 23:59:59 | 2 | 220 | 100 | 55 | 11 | 8 | 5 | 800 | 160.00 | 1 | davinci_sportsbar_rabatt_oslo | 9999 | 2010-07-12 00:00:00 | Da [NAME]
Oslo | 21771 | 17150 | 6098 | 90 min biljard + 2 mineral vann pÃ¥ eksklusive [NAME]! | 2010-06-13 00:00:00 | 2010-06-13 23:59:59 | 2 | 289 | 120 | 58 | 8 | 5 | 5 | 600 | 120.00 | 1 | buddha_biljard_oslo_rabatt | 9999 | 2010-09-13 23:59:00 | [NAME]
Oslo | 20424 | 16936 | 5937 | Et herlig eksotisk mÃ¥ltid [NAME] beste indiske restaurant | 2010-06-14 00:00:00 | 2010-06-14 23:59:59 | 2 | 198 | 99 | 50 | 56 | 53 | 27 | 5247 | 194.33 | 1 | gandhi_rabatt_oslo | 9999 | 2011-06-14 23:59:00 | [NAME]
 |  |  |  |  |  | What I want is to merge the dates such that:
 |  |  |  |  |  | Date | Turnover
 |  |  |  |  |  | 2010-06-06 23:59:59 | 2796
 |  |  |  |  |  | 2010-06-07 23:59:59 | 15960
 |  |  |  |  |  | 2010-06-08 23:59:59 | 9072
 |  |  |  |  |  | 2010-06-09 23:59:59
 |  |  |  |  |  | 2010-06-10 23:59:59
 |  |  |  |  |  | 2010-06-11 23:59:59 | 1078
 |  |  |  |  |  | 2010-06-12 23:59:59 | 800
 |  |  |  |  |  | 2010-06-13 23:59:59 | 600
 |  |  |  |  |  | 2010-06-14 23:59:59 | 5247