I have a worksheet that sorts countries into Zones which looks the table on the left (a lot of blank cells) is there a way to compact this so it shows only the cells that are populated similar to the table on the right?


Data.jpg