fill down empty rows

fill_down_example.xls

Hi, as you can see in the attached file, I want to have a macro that fills down the As in the first column until it reaches the B and then fills down the B, etc.

I hope this explains it.