I ran into that with City1, it had Suite Numbers in it and I didn't want that. Plus, it wouldn't pull the data from City2 if the Suite Numbers were there. But i noticed that City 2 was always populated with a city name. So I just flipped it and pulled the City name from City1 into City 2 and used City2 as my clean column.
I have a years worth of data that I compared and it was all the same. City2 was the column to us and if City 2 was blank, I pulled the name fromCity1 over to give me a complete column.
Brian D. Brubaker Business Intelligence Analyst Viega LLC