How often have you seen an Excel worksheet where a single entry in Column A applies to several rows of data? Sort this list by name, and those blank cells make it impossible to tell who sold what in February and March.

When a list is small, you can enter the missing names manually. But if your database is huge, you need a better way of filling in those names. Here's how: