Students have an ID, Name, and English Level in one spreadsheet. They have an ID and achievement on a standardized test on another spreadsheet.
I need to match the ID's and put the English level into the standardized test results.
I was under a deadline and actually accomplished this by importing into mysql and running update queries BUT I think there has to be an easier way with Excel or Open Office.
Any links to a good tutorial? I've watched videos and read about pivot tables but I'm not having any luck yet.