merging data from 2 lists

[Me]

Hi,
I have 2 lists of students - both lists are exactly the same; in one list
certain students have a grade, in the other list all the other students have
a grade.
No student has a grade on each list; how do I end up with one list of
students which has all the grades in the correct place?
i am sue this is simple - but not for me!!

thanks
Me

 

[Dave]

Hi Me,
Definitely sounds possible, but we'll need some detail on the nature of the
"lists"
Are they single column? Multiple column?
Are the grades in the same cell as the students' names?
Dave.