st: Data Manipulation Question

[Socrates Mokkas <socrates.mokkas@economics.oxford.ac.uk>]

Hi Listers,

I have a question related to data manipulation. My data sample is like that:

Parent       Subsidiary
A            B
             C
             D
             F
X            J
             L
Z            T

What I want is to fill the gaps of the ParName. This is to replace the missing values of C, D, F with A, and the missing value of L with X. Each Parent has a different number of Subs.
Any ideas?
Thanks in advance.

Regards,

Socrates

*
*   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/