Introduction to filling in gaps in Excel
In this module of the Data Cleanup in Excel course, we cover the various ways to fill in gaps in an Excel report so that it becomes a data base that can be used elsewhere.
Instead of you manually copying each section down (as shown below), you can use tools andĀ formula
to quickly and safely make the report above look like this
We also show the more complex situation where you need to fill in the gaps, but some of the key information (city names in the example below) is mixed in the same column as some of the data. We need to get it out into an adjacent column but make sure it correctly lines up with the data.