Hi group, been scratching my bonce for a while and I can't crack this
one.....

I have a worksheets containing pupils' exam results.

For each exam that the pupils take thier results go into a group of
fourcolumns, in the following order
date, % score, grade, target grade

There are around 10 of these groupings, one for each exam that pupils
take in the course of a year.

I would like to be able to sort the groups of columns by date, keeping
the four related columns adjacent to each other, so that they appear
in the order that pupils took them, rather than

there are blank columns where pupils have not taken exams yet, and
blank results within columns where a pupils was absent for a test.

Any suggestions gratefully received.

Many thanks.

Tony