Thanks so much, Richard, but unfortunately, I have a need not only to keep
the primary record, but to add to it for each secondary record. So for
instance, on the first record, I have the person's name and address and the
details related to one degree that the person has earned. On the second
line, I have the details related to another degree the person has earned -
and need to move that data from the second record to additional columns under
the first record. Unless someone knows of a way to consolidate the data
using the Word Mail Merge function.

Thanks for any help you can give!
Kristin

"Richard Buttrey" wrote:

On Mon, 10 Oct 2005 07:41:03 -0700, "Richmond"
wrote:

I have a spreadsheet with multiple records per person and I need to move the
data from the secondary listings to the first record so that I have only one
record per person, as this data is going to be used for a mail merge.

Any suggestions for how to do this quickly?

Assuming you want the second record to completely replace the first
record, then the approach I'd adopt is:

1. Sort the records by person
2. Use a helper column with the following formula

=IF(COUNTIF($A$15:$A$20,A15)1,IF(A15=A16,"XX","Li st"),"List")

Assumes the person name is in column A, and a 6 row data set (rows
15:20) - change as appropriate.

3. Now filter the list on "XX" and delete the duplicate (first)
records.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________