I understand that once a cell is highlighted you can drag it to populate the following cells. Is there a function that can do this automatically to the next populated cell? The reason being is that my report has hundreds of lines and its too time consuming doing this one name at a time.

What I have now
Name Grade
Ted 3
3
3
Susan 4
3


What I want
Name Grade
Ted 3
Ted 3
Ted 3
Susan 4
Susan 3


Thanks