insert a blank row for a missing value of a repeated sequence

Hi,

I am having issues with organizing some data. In column A i have a series of countries listed in alphabetical order. In column B i have years in a repeated sequence. In column C I have variable data corresponding to each year for each country. For example

Argentina 1980
Argentina 1981
Argentina 1983
Argentina 1984
Brazil 1980
Brazil 1981
Brazil 1982
Canada 1980
Canada 1981
Canada 1984

As you can see i have a sequence of years which in my actual data is 1980-2006 for each country but there are some missing years. I would like to insert a blank row for every missing year. Any help is greatly appreciated.

thanks!

Hi MarvinP,

Thanks a lot for the reply. Unfortunately, when i click on the button it only produces Argentina with the corresponding years of 1980-2006. I have attached a copy of my actual excel data in hopes that it will give you a clear picture of what I mean. You will notice that I have 60 countries in column A spanning between 1980-2006 but some of the years for the countries are missing. I was hoping to insert a blank row where the missing years should be for each country so that in the end I would have an equal amount of rows per country. Any help would be greatly appreciated. Thanks again for the response.

Thanks alot MarvinP! It worked perfectly.