st: repeating strings

["MA V" <ma_v@hotmail.com>]

Hello,
I believe that there is an easy answer for my problem but I can't seem to 
find it anywhere...
I have a table with the following format (this is a toy example where we 
have the cities in which each person has lived - city1 is where each person 
lived first):

name city1 city2 city3
John  SF       .     .
John     .     Chi     .
John     .      .      LA
Mary      .      NY    .
Mary   Chi       .     .
...

What I would like to do is to fill in the missing values with the city 
strings, i.e. I would like to get at the end:

name city1 city2 city3
John   SF     Chi    LA
John   SF     Chi     LA
John   SF      Chi    LA
Mary   Chi      NY    .
Mary   Chi      NY     .
...

Any suggestions?
Thanks!

_________________________________________________________________
Get today's hot entertainment gossip  
http://movies.msn.com/movies/hotgossip?icid=T002MSN03A07001

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/