If this is just a one-off fix, I'd use a formula instead of a macro. Assuming aaa is in cell A2, enter =IF(B2="",C1,B2) into C2, then copy C2 into the rest of column C. If column B contains a value, it will use that. Otherwise it will pick up the value from the cell above it.
ColA, ColB...