Hi,

Here is sample date from an excel spread sheet.

Cityname, FirstName, LastName
-------------------------------
Kansas, Tob, Seven
, Amy, Cheng
, Rob, Thomas
Dallas, Steven, Tall
, Bob, James

How do I generate this output using excel tricks?

Cityname, FirstName, LastName
-------------------------------
Kansas, Tob, Seven
Kansas, Amy, Cheng
Kansas, Rob, Thomas
Dallas, Steven, Tall
Dallas, Bob, James

Basically, repeat City Name, tilll new city name is found...something like that.
Appreciate help,
Brgds.