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.
Bookmarks