I am going to be merging 2 sets of data, one of 2006 information and one from
2007. In each year there are different university names, which I have in my
rows, and the amount of students who applied for each year in the columns.
Like the example below

Uni Name 2006 2007
Brighton 23 8

My dilemma is that I am getting each set of data from seperate places, and
some univeristies will be the same while others will be different. I want to
create the spreadsheet so when I copy both sets of data, duplicate entries
are removed and the data for 06 and 07 line up next to the university name.
Is there a way of doing this? I am aware of mail merge but have never really
used it.

Cheers