I need some clarification. Comparing the 2 files, the first row you want to remove is row 18 which has "Apartment 8" in column A and "MDU Self Monitored Security" in column E. However, in the Outcome file, "Apartment 8" still appears in column A. The same is true for the other rows containing "MDU Self Monitored Security ". In the De-sensitized file, Rows 39 to 43 contain "220 Riverside Ave Unit 651" in column A. I can understand why row 42 (duplicate row) would be deleted but why are rows 39 to 41 and row 43 also deleted? Those rows don't appear in the Outcome file.
Bookmarks