I am required to merge 5 data sets into one. Not all data sets had the same variables so I have linked the datasets as best as I can. I am now having issues with a couple of the observations, for example:    Bahamas               60 9   Bahamas (the) BS BHS       2.9 367168       Bahamas, The   BHS 29930 High Income               This is clearly all data relating to the same country, however it is not in one row.    How can I make the data look like this?   Bahamas BS BHS 29930 High Income   2.9 367168 60 9     Thanks ... View more