How are the 2 columns related? I did a quick filter and cannot see any real pattern- how are the names assigned to the location? If it was a case of everything between 1000-2000 going to A, 2001-3000 going to B etc it would be simple, but it doesnt appear to be the case. Bit more info would be useful so we can seethe link is.