Filling in a column below a cell until a new value is encountered and proceeding

[Christy C]

I know I used to do this in excel all the time but I can't remember how to get there. I have a column (A) with Names. Column (B) has a list of the items associated with the person in column A but the Name is only in the first line. I want to quickly fill in the rows beneath. My actual spreadsheet has names and items. Can you help me fill it in without having to double click on Bob to fill then double click on Sue to fill the items included in her list and on down?

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Bob[/TD]
[TD="width: 64"]Truck [/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD]Car[/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD]home[/TD]
[/TR]
[TR]
[TD="class: xl64"]Sue[/TD]
[TD]Truck [/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD]Home[/TD]
[/TR]
[TR]
[TD="class: xl65"]David[/TD]
[TD]Car [/TD]
[/TR]
[TR]
[TD="class: xl65"] [/TD]
[TD]home[/TD]
[/TR]
[TR]
[TD="class: xl65"] [/TD]
[TD]motorcycle[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

Lets say this table is in A1:B8. Select A1:A8. Press CTRL-G. Press Special. Click Blanks radio button. Press = then the up arrow key. Press CTRL-ENTER.