So I have a column that is the ID and then I have an address column that has all of the addresses listed in it. It is separated in the cell by a line break. Some of the addresses are basically the same minus a state or zip code. How do I condense it into one? I appreciate your response! You are making my work life alot better!
So I attached a dummy file- you can see that column D is the address field and that multiple are listed. How do I condense or combine the ones that are basically the same? Any help would be the best!!!