How to separate an observation entered within an observation and use some of the content

[Aye Aye Khaine]

Hello,

I have a dataset that is collected at village (group) level with randomly selected households that have more than one child (observations). Many of the responses on demographic variables are the same. However, information on child-related variables are not the same for each child.

How can I create new observation for additional child within a same household at a same village in stata?

Please help.

Thank you.