This is what the lookup functions are for.

Starting with the existing table.
Create another table, empty except for the first I'd "000"
Fill in the other values for 000 using lookup functions that reference the original table.
Use the fill down drag handle to populate the entire table.
There will be errors where the original table is missing id's, unless the formulas employ error trapping.
Convert the new table to static text via copy> paste special as values.