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

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