Spreadsheet: 41579d1240084639-comparing-and-deleting-data-in-2-columns-test-data
Sheet: Original DB

UniqueId | ReferenceNo | cardnumber | carddesc | designation | department | LastDoor | SwipeDate
28110 | 5 | 4167 | A Belatreche | Senior SHO | Oral Maxfax | 6 OPT Entrance [121] | 2005-05-19 00:00:00
28111 | 6 | 4167 | A Belatreche | Senior SHO | Oral Maxfax | 2 Staff DischargeLounge | 2005-05-16 00:00:00
28112 | 4 | 4167 | A Belatreche | Senior SHO | Oral Maxfax | 2 MAT Main Ent [107] | 2005-04-11 00:00:00
28113 | 7 | 4167 | A Belatreche | Senior SHO | Oral Maxfax | 28 OPD StreetEntry [81] | 2005-05-22 00:00:00
28114 | 2 | 4167 | A Belatreche | Senior SHO | Oral Maxfax | 13 EAST C/P ENTRY | 2005-05-12 00:00:00
28115 | 3 | 4167 | A Belatreche | Senior SHO | Oral Maxfax |  | 00:00:00
28116 | 12 | 4167 | A Belatreche | Senior SHO | Oral Maxfax |  | 00:00:00
32591 | 8 | 4167 | A Belatreche | Senior SHO | Oral Maxfax | 24 NUC StreetEntry [117 | 2005-05-03 00:00:00
32592 | 9 | 4167 | A Belatreche | Senior SHO | Oral Maxfax | 1 NUM StreetEntry [134] | 2005-02-12 00:00:00
130583 | 10 | 4167 | A Belatreche | Senior SHO | Oral Maxfax |  | 00:00:00
104975 | 3 | 6876 | A Clowes | Treetops |  | 32 Ind St XOver Rr[32] | 2009-02-07 00:00:00
104977 | 2 | 6876 | A Clowes | Treetops |  | Barrier out hosp rear | 2009-04-03 00:00:00
176778 | 4 | 6876 | A Clowes | Treetops |  |  | 00:00:00
11017 | 3 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. | 32 Ind St XOver Rr[32] | 2009-01-13 00:00:00
12432 | 2 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. | 9 S4 C/P EXIT | 2009-04-08 00:00:00
21645 | 7 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. | 10 AED Childrens [253) | 2009-04-08 00:00:00
24315 | 4 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. |  | 1999-12-30 00:00:00
54465 | 12 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. | 16 OPD [NAME] | 2009-04-06 00:00:00
117473 | 10 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. |  | 1999-12-30 00:00:00
164241 | 5 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. |  | 1999-12-30 00:00:00
164242 | 6 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. |  | 1999-12-30 00:00:00
164243 | 8 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. |  | 1999-12-30 00:00:00
164244 | 9 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. |  | 1999-12-30 00:00:00
14975 | 2 | 3290 | A K Narayansamy | SHO | Anaes | 5 Trust HQ [31] | 2006-02-02 00:00:00
14976 | 3 | 3290 | A K Narayansamy | SHO | Anaes |  | 00:00:00
18708 | 5 | 3290 | A K Narayansamy | SHO | Anaes | 4 OPT Entrance [126] | 2006-02-03 00:00:00
18709 | 6 | 3290 | A K Narayansamy | SHO | Anaes | 12 CHU Entrance [158] | 2006-01-25 00:00:00
18710 | 4 | 3290 | A K Narayansamy | SHO | Anaes | 31 V2 C/P Entry [???] | 2005-11-14 00:00:00
41466 | 8 | 3290 | A K Narayansamy | SHO | Anaes | 13 NUE/NUC Divide [115] | 2006-02-02 00:00:00
41467 | 9 | 3290 | A K Narayansamy | SHO | Anaes | 1 NUM StreetEntry [134] | 2005-11-22 00:00:00
41468 | 7 | 3290 | A K Narayansamy | SHO | Anaes | 23 EastStairFireDr[503] | 2006-02-01 00:00:00
41469 | 12 | 3290 | A K Narayansamy | SHO | Anaes | 11 1st Fl WestLiftLobby | 2005-02-14 00:00:00
124443 | 10 | 3290 | A K Narayansamy | SHO | Anaes |  | 00:00:00
139764 | 7 | 8991 | [NAME] | SHO | T&O |  | 00:00:00
139765 | 9 | 8991 | [NAME] | SHO | T&O | 2 MHD StreetEntry [135] | 2007-02-08 00:00:00
139766 | 8 | 8991 | [NAME] | SHO | T&O |  | 00:00:00
139768 | 10 | 8991 | [NAME] | SHO | T&O |  | 00:00:00
139769 | 4 | 8991 | [NAME] | SHO | T&O |  | 00:00:00
139770 | 6 | 8991 | [NAME] | SHO | T&O | 4 NUG Entrance [150] | 2007-02-08 00:00:00
139771 | 5 | 8991 | [NAME] | SHO | T&O | 6 OPT Entrance [121] | 2007-02-12 00:00:00
139772 | 3 | 8991 | [NAME] | SHO | T&O |  | 00:00:00
139774 | 2 | 8991 | [NAME] | SHO | T&O |  | 00:00:00
5094 | 3 | 2824 | a.grove  2824 | gardener | Interserve | 3 [NAME] exit (side)[19] | 2009-04-07 00:00:00
11166 | 2 | 2824 | a.grove  2824 | gardener | Interserve | Barrier out hosp rear | 2009-04-08 00:00:00
22441 | 4 | 2824 | a.grove  2824 | gardener | Interserve | 34 MAT C/P Exit [???] | 2009-03-06 00:00:00
101695 | 12 | 2824 | a.grove  2824 | gardener | Interserve | 17 Back Road Ramp IN | 2009-04-08 00:00:00
121104 | 10 | 2824 | a.grove  2824 | gardener | Interserve |  | 1999-12-30 00:00:00
3596 | 2 | 596 | a.hughes  596 | porter | Interseve | Barrier out hosp rear | 2009-04-06 00:00:00
5091 | 3 | 596 | a.hughes  596 | porter | Interseve | 4 FM Main Entrance [17] | 2009-04-04 00:00:00