I need to match two columns (B and C) and move down the values (C and D) inserting an empty line where there's no match.
Is there a formula that can do this?
You should have the tables structured so that the leftmost column is the key, i.e. the unique identifier. In this case, that would be their names. After that, you can simply use
VLOOKUP to look up a key in a second table. You can wrap that
VLOOKUP in an
IFERROR to hide errors by making them equal empty strings (i.e. "")
In your example, column C is redundant, so here's how I'd structure it:
For copy-and-paste purposes, the formula in
=IFERROR(VLOOKUP($A1,$A$7:$B$9,2,0),"") -- then just drag down