I have data from different sources, some use names for a country and other sources use different name. Such as Hong Kong and Hong Kong, China. I merged the data but I have the two countries separate with different IDs. I want to merge both together in one ID and unify the name to be Hong Kong and merge all the variables together under this name. Thanks for helping.