Hello all,
I have attached a list of car parts. The first two columns are the years the part is available in, for example cell A1 is 1995, and A2 is 1998. I need to create blank rows beneath each entry to accomodate each year indivudually. I am having to manually insert, in this example, 3 blank rows and autofill down (I need the whole row to autofill down). When you see the excel file you will see I have almost 18,000 rows that need to be done by end of day Friday (April 20).

Is there any equation or something that I could use to do this. The problem is that all the year avalabilities are not the same. Some parts are only for one year, and some 2, 5, 4... etc. in no particular order. Is this even possible?

WAC spreadsheet years.xlsx