Hi

I am using a large excel file, in both 2003 and 2007 versions. The data
contains exam results based on exams 6 years apart and looks like this.

KS2 Grade KS4 Grade
4 6
5 8
3 2
5 5
5 5

I need to produce a matrix which looks like this:

KS4 1 2 3 4 5 6 7 8
KS2
5 2 1
4 1
3 1
2

Any help is much appreciated with many thanks in anticipation.

Best wishes

Nick