outer join in Gnumeric

Hi guys: 
maybe one of the experts here can provide some advice...

I have two spreadsheets containing grades for two different exams
(midterm 1, midterm2) for  the same class. For simplicity, we can
assume that each contains the following filed:
ID Name Grade 

I need to merge them creating a single spreadsheet with all grades for
all students who took at least one of the exams. If the list of
students was the same, I could just copy-and-paste a column. However,
the lists are slightly different: some students missed one midterm,
others the second midterm, some dropped the class, etc.

Is there any simple way of merging them, short of manually matching
(there are about 900 students)? Of course, if using a database - such
as MySQL - it would be exactly one command [AFAIK, it is called "full
outer join"]. But I do not know MySQL, and learning it, converting the
data, and then converting back seems too much of a hassle for such a
simple thing.

Is there any way to do it in Gnumeric? Or in OpenOffice.org? In Excel
if there is no other way? [BTW: Microsoft Access database doesn't
support outer join. Typical for point-and-click products)


PS: I know the right way would be to keep all the data in a single
spreadsheet, avoiding this problem. However, for reasons you do not
want to know, it was impossible - and it is too late now, anyway.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]