Hopefully, your data is set up something like this:
Name	Month
Alpha	Jan
(blank)	Feb
(blank)	Mar
Bravo	Jan
(blank)	Feb
(blank)	Mar
(blank)	Apr
(blank)	May
Charlie	Jan
(blank)	Feb
(blank)	Mar
(blank)	Apr
If that's true....try this:

Select from the 1st name down through the last blank celll to be associated with the last name.

Press [F5]........a shortcut for <edit><go to>
Click [special]....Check: Blanks......Click [OK]

Next....While all of the blanks are selected.....
Press =...press the [UP ARROW] key one time...
Hold down [CTRL] and press [ENTER]

Now every blank cell refers to the cell above it.

If you want to "hardcode" those values....
Select the column of names.
<edit><copy>
<edit><paste special>....Check: Values....Click [OK]

Does that help?