Sorry if this is a newbie question, but…
I have a single spreadsheet containing several worksheets.
On each worksheet is a table of countries, along with data gathered from different sources.
So for example, on worksheet 1, I have a list of countries by per capita GDP from the world bank. On worksheet 2, I have a list of countries by disposable income from the OECD.
The problem is, these lists of countries aren’t exactly the same. The World Bank list might have 156 countries, but the OECD list might have 175 countries.
Is there a way to combine these different sources into a single list? e.g. I want to have a master table of countries with both per capita GDP and disposable income.
Bookmarks