how to create a complete series from a partial series

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Make it realistic and include any other columns that need to move as you insert rows.

You could put this in the first row and drag it down.

Formula:

Please Login or Register  to view this content.

Use VLOOKUP to bring across any matching data. Copy the output and Paste Special | Values to remove the formulae.