I have two sets of data that I am struggling to combine withiout having to do
so manually. The data is from two different years, some names appear in
both lists, some only in one list and not the other (sample below). I need
to combine the two sections of data into one list, eliminate the duplicate
names and combine the data for the duplicated names in to one entry.

first last 07-08 first last 06-07
Connie Aalderink 16 Connie Aalderink 24
Ryan Aalderink 8 Jerry Aardema 27.75
Jerry Aardema 51.5 Mary Abbring 41.5
Reta Ademe 30.75 Reta Ademe 11.5
Adan Aguilar 32 Nikki Afendulis 16
Anthony Aiuppy 24 Adan Aguilar 37.5
Khamtanh Akhavong 31.25 Patricia Aittama 28

What I need to do is if the name appeats in the 06-07 AND 07-08 columns. I
need move it to a new report that combines the data with first name, last
name, 06-07 and 07-08 data so it looks something like the sample below.

I also need to move the data that is unique to one list and not the other
list,

first last 07_08 06_07
Connie Aalderink 16 24
Ryan Aalderink 8
Jerry Aardema 51.5 27.75
Mary Abbring 41.5
Reta Ademe 30.75 11.5
Nikki Afendulis 16
Adan Aguilar 32 37.5
Patricia Aittama 28
Anthony Aiuppy 24
Khamtanh Akhavong 31.25

Have tired several ways around this and not finding a solution that works.

Appreciate any assisstance
--
debra