Spreadsheet: 90096d1289851783-combining-2-sets-of-data-deleting-uncommon-names-delete-duplicates-from-column-d-test-document
Sheet: Sheet1

F6 | F9 | F4 | Patient Demographics | Patient | DOB | G | FGP | Type | Status | Employment | First Visit | Last Visit | Next Visit | Default Provider | Fac Code | Maiden Name
Anchorage, AK  99501 | 99501 | 222 Second St. | Palin, [NAME] | Doe, [NAME] | 1956-09-19 00:00:00 | F | AET |  | Active | Unknown | 2008-01-30 14:18:20 | 2008-10-06 15:59:42 |  | Jones
Juneau, AK  99801 | 99801 | 101 Caribou Cr. | London, [NAME] | [NAME], [NAME] | 1948-07-08 00:00:00 | M | UNH |  | Active | Unknown | 2010-07-14 14:31:47 | 2010-09-13 10:08:06 | 2010-10-21 14:00:00 | Jones
Anchorage, AK  99501 | 99501 | 1 Smith Street | Doe, [NAME] (M54) | [NAME], [NAME] | 1935-04-12 00:00:00 | F | HF |  | Active | Unknown | 2008-12-16 09:12:54 | 2010-06-01 10:31:08 |  | Smith
Anchorage, AK  99501 | 99501 | 2 Smith Street | [NAME] (M62) | Red, Rose E | 1931-08-02 00:00:00 | F | CP |  | Active | Unknown | 2008-09-15 15:17:50 | 2010-09-13 13:13:19 |  | Smith
Fairbanks, AK  99705 | 99705 | 180 Slalom Way | Moe, Tommy | [NAME] | 1925-03-27 00:00:00 | M | AMC |  | Active | Unknown | 2010-10-11 14:21:20 | 2010-10-11 14:21:20 | 2010-10-20 10:00:00 | Jones
Anchorage, AK  99502 | 99502 | 3 Smith Street | [NAME] (F75) | Armstrong, Louis | 1930-12-05 00:00:00 | M | AMC |  | Active | Unknown | 2005-08-22 08:53:51 | 2010-05-03 08:58:39 |  | Smith
Anchorage, AK  99503 | 99503 | 4 Jones Street | Red Rose E (F79) | [NAME], [NAME] | 1933-08-22 00:00:00 | F | HFH |  | Active | Unknown | 2008-11-12 13:31:35 | 2008-11-12 13:31:35 |  | Jones
Barrow, AK  99723 | 99723 | 21 Solstice Street | [NAME] (F100) | Flowers, [NAME] | 1941-12-15 00:00:00 | F | AMC |  | Active | Unknown | 2010-05-10 15:30:13 | 2010-10-01 09:39:40 | 2010-10-21 10:40:00 | Smith
Anchorage, AK  99502 | 99502 | 7 Brown St. | [NAME] (M85) | Almodovar, [NAME] | 1946-04-14 00:00:00 | M | AMC |  | Active | Unknown | 2010-07-14 14:18:39 | 2010-09-24 10:05:43 | 2010-10-21 11:00:00 | [NAME]
Anchorage, AK  99505 | 99505 | 9 Happy St. | Armstrong, [NAME]  (M79) | [NAME], [NAME] | 1966-08-07 00:00:00 | M | AU | CAR | Active | Unknown | 2008-04-29 08:40:32 | 2008-12-11 09:28:58 |  | [NAME]
Anchorage, AK  99513 | 99513 | 20 Colony Rd. | [NAME], [NAME] (F77) | Contrary, [NAME] | 1953-05-18 00:00:00 | F | PPO |  | Active | Unknown | 2008-09-29 12:51:25 | 2008-10-28 12:50:28 |  | Smith
Anchorage, AK  99509 | 99509 | 12 Shell Cir. | Flowers, [NAME] (F68) | Smith,  [NAME] | 1926-07-08 00:00:00 | F | HF |  | Active | Unknown | 2010-07-23 14:47:51 | 2010-10-19 10:15:17 | 2010-11-15 13:00:00 | [NAME]
Barrow, AK  99723 | 99723 | 24 Solstice Street | Lights, Northern | Sunnybrook [NAME] | 1954-11-08 00:00:00 | F | TRI |  | Active | Unknown | 2010-05-13 15:00:44 | 2010-10-05 09:58:45 | 2010-10-27 13:00:00 | Smith
Anchorage, AK  99510 | 99510 | 12 Shell Cir. | [NAME](M64) | Mecrazy, Shameka | 1979-10-10 00:00:00 | F | WMC | WC | Active | Unknown | 2010-06-07 14:16:34 | 2010-09-27 08:42:55 | 2010-10-26 08:00:00 | Smith
Anchorage, AK  99511 | 99511 | 382 [NAME] | [NAME], [NAME] (M44)
Juneau, AK  99801 | 99801 | 247 [NAME]. | Catrrall, [NAME]
Anchorage, AK  99512 | 99512 | 30  Garden Grow Rd | Contrary, [NAME] (F57)
Fairbanks, AK  99705 | 99705 | 1010 Tenor Trail | Buble', [NAME]
Anchorage, AK  99513 | 99513 | 10 Frisco St. | [NAME]  (F84)
Juneau, AK  99801 | 99801 | 11 Enterprise Way | Doohan, [NAME]
Anchorage, AK  99514 | 99514 | 97  Atlantic Court | Sunnybrook, [NAME] (F55)
Anchorage, AK  99515 | 99515 | 27 Carolina St | Mecrazy, Shameka  (F30)