Is there a way to autofill down a column, where the autofill detects a new
value and uses that value, until the next time it hits a new value? Simple
example:

I want this: To look like this:

Dave Dave
Dave
Dave
Bill Bill
Bill
John John