Remove blanks dynamically in range with blank cells

Hi,

Here's one way that uses a dynamic range name "lst" that expands and contracts automatically to cover your range of names, a pivot table based on that range, and a sheet change macro that automatically refreshes the pivot table when you add a new country.

There are no doubt array formulas too that you could use although these tend to be a bit opaque and difficult to 'read'.