Introduction to filling in gaps in Excel

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

introduction-to-fill-in-gaps-in-excel

to quickly and safely make the report above look like this

introduction-to-fill-in-gaps-in-excel

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.

introduction-to-fill-in-gaps-in-excel

 

Back to: Data cleanup in Excel > Filling in gaps