0 of 45 lessons complete (0%)
Filling in gaps

Introduction to filling in gaps in Excel

This is a preview lesson
Purchase this course, or sign in if you’re already enrolled, to take this lesson.

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