How to fill in missing data part 2

Here again we have a music collection with some missing data.

The twist, in this case, is that the Artist isn’t in the right column.

As before, we’ll use formulas to fill in the missing data.

But this time, we need to take care of the artist rows as a first step.

With all the cells in column B selected, enter an equal sign to start off a new formula.

We can do this with theIFandISBLANK functions.

Control-Enter to add the formula to all selected cells.

This nicely fills in the Artist column.

As before, this will create a chain of formulas.

Most formulas simply get a value from the cell above.

Do this with Go To Special.

First select all the values in a column where the artist rows are blank.

Next, use Go To Special > Blanks to select only the blank cells.

Finally, use Control - (minus) for Delete, and select Entire Row.

That’s the end of the Artist rows.

Now follow the same process we used earlier.

grab the entire table and use Go To Special > Blanks.

Then enter a formula that refers to the cell above and use Control-Enter.

Finally, usePaste Special> Values to replace all formulas.