Hi,
I am trying to consolidate country data from two different sources. One of the sources has data on GDP growth for 252 countries. The other has data on Voice and Accountability ratings for only 216 countries. I want to get rid of Column C (country names from data set with only 216 countries) and match up Column D values to their appropriate country names in Column A.
Thus, my goal is to keep Columns A and B the same, get rid of Column C, and get the values for Column D in the appropriate rows (some rows will be empty to represent missing countries data).
Please let me know if you know how to do this (otherwise I will be laboriously doing this by hand). Thank you in advance!!!
Bookmarks