Mar 15 2021 04:11 PM
Hi,
I have about 20 country-level data (e.g. GDP, education, life expectancy. ) on 20 different sheets, and I want to merge them on a single sheet by the country variable. I ranked the countries alphabetically to facilitate the merge, but the issue is that data for some indicators are missing for some countries. So I'd like to know if there is any special function shortcut to perform this. My goal is to make only the countries present in all the sheets. I found the VLOOKUP option on a website, but that looked complicated to me.
Thank you.
Thank you.
Mar 16 2021 01:29 AM
To my knowledge no, there is no such built-in function which will do such merging at once. That's more job for Power Query, if with functions - VLOOKUP, XLOOKUP and like.