Hi @jivansj
I am not so sure whether this was a query or a comment. I would however like to make a general comment:
- When you move parent information to the childrens’ shee, you are basically creating a long data format which means that the family information will be added to each child so if a family had 3 children, then your merge will create three family information onto the 3 children.
- When you move children information to parent sheet, you have to convert it to wide format where each row represents a family and then the children are added as indexed columns e.g. if you had a variable say childname, then for three children you will have to add childname1 childname2 childname3. this process will be repeated for all variables.
With the above 2 principles in place, you have to to convert your sheets appropriately to perform the merge.
Stephane
