Imported data often has missing entries you need to populate.

You can use Power Query, but that duplicates the table.

This technique works on the existing table and is quick and easy to apply once mastered.

Start the clock!