Making a numbered list and inserting blanks

[lkeller]

Lets see if I can explain this well enough....

I have a list of member numbers ie:

0001 green
0002 smith
0007 johnson
00010 jones

Notice these are in order, but there are no numbers or spaces between 0002 and 0007. The end result of my spreadsheet needs to show me ALL the numbers inbetween with blank spaces as their "name". ie:

0001 green
0002 smith
0003
0004
0005
0006
0007 johnson
00010 jones

Does anyone know how to do this? I am having to do the entire list the long way, by seeking out the blank numbers manually and inserting lines. It is taking forever on a 3000 line list.

[Fotis1991]

Hi and welcome to the forum.

If i understand well, then copy-paste the number 0001, where you want and drag down.

Then use IFERROR,INDEX&MATCH, to find the Names.

Is this, works for you?