Spreadsheet: 114774d1310488484-remove-duplicates-but-collect-and-keep-their-unique-id-random-data-clense-_master-sheet2_halfdone
Sheet: Sheet1

ID | Company | City | Contact name | Number | Last Modifed Used | ID of Records to be Merged?
5424 | Convatec (Singapore) Pte Ltd | Brookings | [NAME] | 1 11 936 3479-1575 | 01/25/2009 | 5424
7484 | Facilities [NAME] | Kokomo | [NAME] | 1 98 458 3385-0875 | 06/18/2010 | 7484
920 | Adobe | [NAME] | [NAME] | 1 99 194 6453-2914 | 12/23/2009 | 920 | 6049 | 3368 | 3683
6055 | GTSI GLOBAL | Oxnard | [NAME] | 1 40 242 1389-9855 | 04/20/2008 | 6055
2537 | AEF Limited | West Haven | [NAME] | 1 25 740 6210-4647 | 2008-06-12 00:00:00 | 2537
4292 | Dulux Paints | Kona | Aphrodite Duke | 1 38 321 6919-4822 | 07/15/2010 | 4292
5651 | Altavista | Cedar City | [NAME] | 1 66 642 7770-0576 | 2007-03-12 00:00:00 | 5651
2868 | Maxi Stor Systems Ltd | [NAME] | Autumn Atkins | 1 19 133 5479-7388 | 12/25/2009 | 2868
2408 | Leo Laboratories | El Paso | [NAME] | 1 22 324 8640-7163 | 08/22/2009 | 2408
4942 | Europlex Technologies | Geneva | Basia Kline | 1 84 699 8026-9145 | 2009-10-09 00:00:00 | 4942
7239 | Hanley Control Systems Ltd | Gatlinburg | Bell Holden | 1 24 643 9003-6716 | 05/27/2009 | 7239
8157 | Pharmanet Pte Ltd | Portsmouth | [NAME] | 1 35 562 4369-0754 | 10/24/2007 | 8157
8696 | Sirelius | Beverly | [NAME] | 1 24 608 1854-5277 | 2008-05-01 00:00:00 | 8696 |  | 143
7577 | Videojet Technologies Inc | Vail | Chastity Britt | 1 67 959 8963-1035 | 05/27/2010 | 7577
5457 | Corporate Express Ireland | Fort Dodge | [NAME] | 1 63 242 5688-5893 | 12/28/2009 | 5457
933 | Fastrack SW | Revere | [NAME] | 1 14 227 4964-8030 | 06/18/2010 | 933
9114 | Abc Test Training | Elko | [NAME] | 1 33 425 4595-6276 | 03/18/2009 | 9114
6361 | Quintiles East Asia Pte Ltd | Macon | [NAME] | 1 44 854 2613-5901 | 02/27/2010 | 6361
6091 | Apple Comp Systems | Sioux City | Desiree Willis | 1 21 874 8804-8270 | 2009-12-07 00:00:00 | 6091 | 1246 | 3845
9793 | VanRath MWN Financial Selection | Yuma | [NAME] | 1 18 814 7844-2545 | 2008-02-05 00:00:00 | 9793
8688 | Tyco Healthcare Dublin | Eatontown | [NAME] | 1 31 124 7656-4654 | 2008-01-12 00:00:00 | 8688
9281 | Visa International | Orangeburg | [NAME] | 1 38 411 9333-6961 | 09/23/2007 | 9281
1562 | Ericsson Telecommunications Pte Ltd | Mount Pleasant | [NAME] | 1 24 185 9192-2269 | 2007-12-11 00:00:00 | 1562
2758 | [NAME] | Grambling | [NAME] | 1 20 596 4101-8711 | 08/26/2009 | 2758
7385 | Murex S.A.S | [NAME] | Gemma Stuart | 1 82 569 5258-1609 | 11/15/2008 | 7385
5154 | Ruberoid Building Products Ltd | Midland | [NAME] | 1 80 433 1343-6801 | 02/13/2008 | 5154
9749 | Modern Tool Ireland Ltd | Rosemead | [NAME] | 1 53 359 7042-5327 | 05/19/2010 | 9749
2775 | [NAME] | Grambling | [NAME] | 1 68 917 4751-3938 | 01/27/2008 | 2775
7122 | Google | Texarkana | [NAME] | 1 65 999 6190-9472 | 2010-06-08 00:00:00 | 7122
1223 | [NAME] | [NAME] | Idola Camacho | 1 36 930 8127-4650 | 11/29/2008 | 1223
1742 | NTR Plc | South Gate | [NAME] | 1 51 300 2934-5655 | 2009-12-08 00:00:00 | 1742
8250 | OCS One Complete Solution Ltd | Radford | [NAME] | 1 70 933 6935-7271 | 12/22/2008 | 8250
9570 | [NAME] | Cape Coral | [NAME] | 1 37 410 5928-7743 | 05/23/2010 | 9570
7700 | Glaxosmithkline Pharmaceutical Singapore | [NAME] | [NAME] | 1 97 848 9323-7833 | 2008-06-04 00:00:00 | 7700
6899 | Information Mosaid Asia Pte Ltd | Shamokin | [NAME] | 1 25 718 4420-3460 | 10/15/2007 | 6899
5198 | Coopers Ltd | Port Washington | [NAME] | 1 86 318 7941-9226 | 09/17/2008 | 5198
7084 | PPD | Lake Forest | [NAME] | 1 33 728 8870-4828 | 2008-04-11 00:00:00 | 7084
7096 | Emergency Freight | Evansville | [NAME] | 1 52 684 6876-3243 | 03/29/2009 | 7096
4503 | Caketalk | Lawndale | [NAME] | 1 30 923 1452-8776 | 2008-02-09 00:00:00 | 4503
9802 | Cakewalk | Morrison | [NAME] | 1 30 923 1452-8776 | 2008-10-12 00:00:00 | 9802
7579 | Covance (Asia) Pte Ltd | [NAME] | [NAME] | 1 88 363 6708-0570 | 2009-12-01 00:00:00 | 7579
4070 | Sibelius | East Lansing | [NAME] | 1 17 664 5133-1441 | 03/23/2010 | 4070 | 3122 | 6241
2921 | Borland | Abilene | [NAME] | 1 39 391 3149-3666 | 2010-03-08 00:00:00 | 2921 | 6576 | 5599 | 2799
1422 | Microsoft | Seal Beach | [NAME] | 1 14 704 2697-9161 | 01/29/2010 | 1422 | 6184 | 2394
7016 | Datacraft Asia Ltd | Oro Valley | [NAME] | 1 88 620 1660-1229 | [NAME] | 7016
2739 | Punch Industries | Kemmerer | [NAME] | 1 83 420 9295-5805 | 01/31/2010 | 2739
8501 | Home Comforts Ltd (Floorwise) | Ocean City | [NAME] | 1 31 955 2010-8788 | 03/23/2010 | 8501
3528 | Apple Systems | Nome | [NAME] | 1 99 923 6794-9326 | 2008-07-09 00:00:00 | 3528
4935 | Allianz Worldwide Care Ltd | Reedsport | [NAME] | 1 75 688 9336-3091 | 2007-04-09 00:00:00 | 4935
9045 | Ppd Singapore | Truth or Consequences | Madeline Holt | 1 38 174 3178-0866 | [NAME] | 9045
3281 | The Gate Theatre | Myrtle Beach | [NAME] | 1 25 893 2539-9075 | 10/23/2009 | 3281
3171 | Solarwinds Software | Waycross | [NAME] | 1 95 779 7638-0173 | 2009-07-12 00:00:00 | 3171
8925 | Hella Ireland Ltd | Nichols Hills | Medge [NAME] | 1 16 229 9585-0663 | [NAME] | 8925
1069 | Nera Telecommunications Ltd | Modesto | [NAME] | 1 58 835 2132-6253 | 10/26/2009 | 1069
157 | Forest Laboratories | Dayton | [NAME] | 1 33 613 8000-2491 | 2009-03-02 00:00:00 | 157
3466 | [NAME] | Riverside | [NAME] | 1 87 768 3376-7021 | 11/23/2008 | 3466
9578 | Chami | Louisville | [NAME] | 1 36 328 6854-2585 | 2009-03-10 00:00:00 | 9578 | 4076
4630 | Lollys Shoes | Elko | [NAME] | 1 98 604 4061-6455 | 01/16/2008 | 4630
4250 | Armitage Shanks | Alhambra | [NAME] | 1 71 868 3577-8178 | 03/25/2009 | 4250
1591 | Lollys | Huntington Beach | [NAME] | 1 75 121 2123-2489 | 2008-07-11 00:00:00 | 1591
9422 | Lavasoft | West Jordan | [NAME] | 1 47 538 4529-4274 | [NAME] | 9422 | 8444
5284 | Contract People | Boulder City | [NAME] | 1 17 232 1658-1668 | 07/18/2008 | 5284
9670 | Dublin Docklands Development Authority | Ventura | [NAME] | 1 71 527 1022-4754 | 05/21/2009 | 9670
5995 | Print Depot | Fargo | Rae Gibbs | 1 80 575 1962-9507 | 12/20/2008 | 5995
3494 | Claymon Laboratories | St. Marys | [NAME] | 1 60 802 9621-4998 | 2010-10-08 00:00:00 | 3494
6862 | [NAME] And Dohme | Peoria | [NAME] | 1 31 293 1728-8660 | 06/15/2008 | 6862
5436 | Club Travel | New Brunswick | [NAME] | 1 95 772 6084-7765 | 06/15/2009 | 5436
3374 | ALLDOCS LTD | Mequon | Scarlet Osborn | 1 90 254 5544-9020 | 12/19/2009 | 3374
1932 | Yahoo | Burlington | [NAME] | 1 98 155 5067-3818 | 07/16/2010 | 1932 | 1922
8197 | Hevac Ltd | [NAME] | [NAME] | 1 31 293 6746-7706 | 12/23/2009 | 8197
5460 | Trintech | Charleston | [NAME] | 1 22 125 5910-6661 | 08/31/2008 | 5460
4473 | Servier Laboratories Ltd | College Station | Vera Shepherd | 1 91 941 6826-0132 | 2010-11-02 00:00:00 | 4473
5152 | Codexis Singapore | Ponce | [NAME] | 1 21 919 4411-2298 | 06/18/2008 | 5152
4425 | Rottapharm | East Hartford | [NAME] | 1 37 149 8183-3856 | 03/25/2008 | 4425 | 7510
9600 | Finale | Palm Springs | Winifred England | 1 49 710 2361-1627 | 2009-10-11 00:00:00 | 9600
2010 | ABS Pumps Ireland Ltd | Placentia | [NAME] | 1 54 974 9842-3099 | 04/18/2008 | 2010
5470 | J C Barret / Richmond Electrical | DeKalb | [NAME] | 1 61 536 6987-9244 | 08/22/2008 | 5470