duplicate rows...merge cells

hello, there is my problem: i have 4 columns, one for number, one for name, one for family member and other for family member name.

my problem is that the majority of the persons have father and mother so i have to repeat number and name of each person and i just want one... for example i have a person like this.

number-------------------name-------------------------family member--------family member name
3 Mário Moreira Campos Father Rui Campos
3 Mário Moreira Campos Mother Virginia Moreira

and i just only want one indication of the number and the name like this

number-------------------name-------------------------family member--------family member name
3 Mário Moreira Campos Father Rui Campos
Mother Virginia Moreira

, i know that i could use merge cells for the number and fot name but i have more than 4000 lines..it is a lot...

i also can eliminate the duplicates but then how i can catch father and mother

could someone knows a solution?

in attach i send a file with some of my data.

regards

Mário

hello, first thanks for your quicky answer. the names arent sorted.
i want file like i sent now in attach.to obtain this result i have to do merge cells for each cell of number and name .

regards

Mário

Hello
Please have a look at attached copy
sheet 1 puts it into the reqired format (I think any way), sheet 1 (2) is a copy of the first except rows E, F, G have been copied, special pasted, values.
You are free to data sort and remove unnessary rows.
Regards
Peter

Sorry we both must of been posting as the same time, I'll have a look at the new post.

hello, maybe i have explained bad. what i want is if in name column the first cell is equal to second merge cell and the same thing for the name, the rest stays the same.

regards

Mário

Please have a look at this, first sheet sorts duplicates.
Copy and special paste, values over top of column A and B.
Sorry this is the only way I can think of getting it into the format you want, except first two columns are not merged.
If niether of the supplied are correct I would have to do some research, I would imagine it will need VBA, and I can't write it.
Sorry
Peter

ok, thanks for yours answers. im gonna to research too

regards

Mário