So, I have data that is on separate pages, and they correspond to a list of countries. For example, on page 1, in one set, I have:
On another page, instead of population, I have countries lined up with obesity instead of population:
country, life expectancy
and I want to merge the data row from each set, to align with the country. e.g. just one view with:
country, population, obesity, HDI, gdp, and life expectancy in sequential columns.
I am sure this is a well known function, but I haven’t found any simple answers. any help appreciated.