Using Excel 2007 - Once a year I receive a large Excel file which contains
student information (name, address, student ID etc.). I use this file to do
several types of Word 2007 merges for our school such as report card labels,
name cards, login id cards, student directory and such.

The problem is that many, not all, children have two records. **I want one
record per child with all the information on one row.** Both records are
identical except one record has the mother's first and last name. The second
record has the father or a grandparent's/guardian's first and last name. Is
there a way to combine this information? Both records have the same address,
phone, etc. Just to clarify that this is not true for all records because
some students only have one parent, thus one record. I have to find a way to
get mom and dad on one record/row. I don't have control over how this
information comes to me.

In the past I have just copied the 2nd record's info, and pasted it into the
last couple columns on the 1st record. Then delete the 2nd record's row.
However, as you can see, this seems like a terrific waste of time, if there
is an easier way.

If there is a way to specify in a Word merge - of which I could post to the
Word forum - then I could do that also.

Thanks to you, in anticipation of your answer.
Becky