Alright so our office is sending letters to about 1400 patients informing them of our change of address coming up as the doctor is joining a new group.
So I have a spreadsheet, using Open Office, and I want to remove any entries that are a duplicate address. This way we don’t send two letters to one household for a husband/wife patient. Is there any way to automate this process instead of just sorting by address and going through manually?
And then, after that’s done, there will be empty lines in the spreadsheet for the removed entries. I’m not sure if this is a problem, but I’m curious if there’s a way to get the spreadsheet to “compact” itself so that there are no blank lines throughout. I have a feeling that empty lines may screw up with whatever automated process their company uses to send out our letters.
The deletion of the duplicates is the most important. I really don’t want to sit here for an hour analyzing every line manually.