Stuck for a Solution

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
.

Relevant Pages

  • Re: How can I duplicate the form data?
    ... How can I make a duplicate copy of the Form Collection? ... duplicate with duplicate keys for lists? ... public void TheHeader(NameValueCollection myForm) ... NameValueCollection nvc = new NameValueCollection; ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Seperating CSV rows into new, seperate files
    ... of a script but it still has one more problem. ... will import the list will ignore duplicate rows. ... >> and I am working on a way to parse a CSV file of class lists from MS ... The difference is that the session number changes. ...
    (comp.lang.python)
  • Re: c05 when pressing ENTER on a list with no enabled entries
    ... Set rowsource to azoot. ... if you have a list based on an array and if you set the ... I've played with this a bit, and found it too easy to duplicate, so I'm ... > is a mover form with two lists. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: move cell contents
    ... > Hi David ... > by a formula in the cell) .. ... >> You are right about the duplicate names. ... >>> from what i gather you've got two lists from which you're picking random ...
    (microsoft.public.excel.misc)
  • Re: intersection
    ... >> If one of the lists contains duplicate elements, ... It is strictly speaking an error to duplicate ... >> members of the set in the list representation, ... With that much description of an implementation dependency that ...
    (comp.lang.lisp)