Spreadsheet: 810944d1672188020-remove-duplicate-rows-in-power-query-based-on-various-conditions-duplicates12_24-1-
Sheet: DuplicatedData

Last_Name | First_Name | Name | DOB | Address1 | Race | Home_Telephone | Sex | Accession_Number | Episode_Date | Status
BADRUM | ESTOW | BADRUM ESTOW | 1996-01-21 00:00:00 | 1122 W AD BLVD | WHITE |  | FEMALE |  | 2020-07-10 00:00:00 | Preliminary
JESSEH | MALCO | [NAME] | 1998-08-02 00:00:00 | 5005 CLIS ST | WHITE | [PHONE] | FEMALE | 200000985 | 2022-09-26 00:00:00 | Final
JESSEH | MALCO | [NAME] | 1998-08-02 00:00:00 | 5005 CLIS ST | WHITE | [PHONE] | FEMALE | 200000985 | 2022-09-26 00:00:00 | Preliminary
BEEB | RAWSO | BEEB RAWSO | 1978-01-11 00:00:00 | 1100 FENT PL | BLACK OR AFRICAN AMERICAN | [PHONE] | MALE | 200111746 | 2022-07-22 00:00:00 | Preliminary
BEEB | RAWSO | BEEB RAWSO | 1978-01-11 00:00:00 | 1100 FENT PL | BLACK OR AFRICAN AMERICAN | [PHONE] | MALE | 200111746 | 2022-07-22 00:00:00 | Preliminary
BELLA | SANTI | BELLA SANTI | 1950-04-02 00:00:00 | 18005 BAHA ST |  | [PHONE] | FEMALE |  | 2020-11-18 00:00:00 | Preliminary
ABLA | RHONDA | ABLA RHONDA | 1934-04-10 00:00:00 | 11113 RAY ST | WHITE | [PHONE] | FEMALE | 2001366600 | 2019-03-29 00:00:00 | Final
ABLA | RHONDA | ABLA RHONDA | 1934-04-10 00:00:00 | 11113 RAY ST | WHITE | [PHONE] | FEMALE | 2001366600 | 2019-03-29 00:00:00 | Preliminary
[NAME] | MARS | ABRA MARS | 1972-09-06 00:00:00 | 3008 STELLA BLVD | WHITE | [PHONE] | FEMALE | 3300000 | 2020-04-28 00:00:00 | Final
TANA | MINA | TANA MINA | 1926-02-26 00:00:00 | 20900 AMIE AVE | WHITE | [PHONE] | FEMALE | 200031 | 2020-06-29 00:00:00 | Final
FIRNEI | ELSI | FIRNEI ELSI | 1954-01-21 00:00:00 | 605000 BROWS DR | OTHER | [PHONE] | FEMALE | 40009273 | 2022-09-16 00:00:00 | Preliminary
RAMS | TANTO | RAMS TANTO | 1906-07-02 00:00:00 |  |  |  | MALE | 23456 | 2021-09-29 00:00:00 | Preliminary
RAMS | TANTO | RAMS TANTO | 1906-07-02 00:00:00 |  |  |  | MALE | 2345678 | 2021-09-29 00:00:00 | Preliminary
ABRENICA | PRESIDA | ABRENICA PRESIDA | 1967-08-30 00:00:00 | 94119 SELVA BLVD | OTHER | [PHONE] | FEMALE | 1019001122 | 2021-02-16 00:00:00 | Final
ABRENICA | PRESIDA | ABRENICA PRESIDA | 1967-08-30 00:00:00 | 94119 SELVA BLVD | OTHER | [PHONE] | FEMALE | 1019651122 | 2022-02-22 00:00:00 | Final
ABUNDIS | GUILLERMINA | ABUNDIS GUILLERMINA | 1933-08-07 00:00:00 | 10043 S HERBS AVE | OTHER | [PHONE] | FEMALE | 78990008 | 2019-12-12 00:00:00 | Final
ACABAL | ROBERTO | ACABAL ROBERTO | 1943-06-11 00:00:00 | 114 FLOSS RD | WHITE |  | MALE |  | 2020-03-09 00:00:00 | Final
ACABAL | ROBERTO | ACABAL ROBERTO | 1943-06-11 00:00:00 | 114 FLOSS RD | WHITE | 55-900-0001 | MALE | 98000001 | 2022-10-31 00:00:00 | Preliminary
 | ESTOW | BADRUM ESTOW | 35085 | 1122 W AD BLVD | WHITE | 0 | FEMALE | 0 | 2020-07-10 00:00:00 | Preliminary
JESSEH | MALCO | [NAME] | 36009 | 5005 CLIS ST | WHITE | [PHONE] | FEMALE | 200000985 | 2022-09-26 00:00:00 | Final
BEEB | RAWSO | BEEB RAWSO | 28501 | 1100 FENT PL | BLACK OR AFRICAN AMERICAN | [PHONE] | MALE | 200111746 | 2022-07-22 00:00:00 | Preliminary
BELLA | SANTI | BELLA SANTI | 18355 | 18005 BAHA ST | 0 | [PHONE] | FEMALE | 0 | 2020-11-18 00:00:00 | Preliminary
ABLA | RHONDA | ABLA RHONDA | 12519 | 11113 RAY ST | WHITE | [PHONE] | FEMALE | 2001366600 | 2019-03-29 00:00:00 | Final
[NAME] | MARS | ABRA MARS | 26548 | 3008 STELLA BLVD | WHITE | [PHONE] | FEMALE | 3300000 | 2020-04-28 00:00:00 | Final
TANA | MINA | TANA MINA | 9554 | 20900 AMIE AVE | WHITE | [PHONE] | FEMALE | 200031 | 2020-06-29 00:00:00 | Final
FIRNEI | ELSI | FIRNEI ELSI | 19745 | 605000 BROWS DR | OTHER | [PHONE] | FEMALE | 40009273 | 2022-09-16 00:00:00 | Preliminary
RAMS | TANTO | RAMS TANTO | 2375 | 0 | 0 | 0 | MALE | 23456 | 2021-09-29 00:00:00 | Preliminary
ABRENICA | PRESIDA | ABRENICA PRESIDA | 24714 | 94119 SELVA BLVD | OTHER | [PHONE] | FEMALE | 1019001122 | 2021-02-16 00:00:00 | Final
ABUNDIS | GUILLERMINA | ABUNDIS GUILLERMINA | 12273 | 10043 S HERBS AVE | OTHER | [PHONE] | FEMALE | 78990008 | 2019-12-12 00:00:00 | Final
ACABAL | ROBERTO | ACABAL ROBERTO | 15868 | 114 FLOSS RD | WHITE | 0 | MALE | 0 | 2020-03-09 00:00:00 | Final