help advice needed

Hi

I was hoping someone will be able to help me.

I have a column in a sheet, like the following example

steven
1
1
1
1
1
Bill
2
2
2
Chris
3
3
3
3
3
3
3
3

So the persons name can be followed by an unlimited number of rows. I don't know whether it will make a difference but the persons name is in blue. I want to be able to fill the persons name down overwriting the numbers below, until the next persons name is reached.

I am a complete novice, so any help whether a) it is possible, and b) how to go about it would be very much appreciated.