Hi folks,

I'm sure the answer to this must be posted somewhere on this group but
I can't find it!

I have a set of data containing exam results from pupils. The pupils'
names are given in column A,
then for each test that they complete there are 5 pieces of
information, starting with the date the test was taken in column B,
then the test score C, grade this gets in D and two other things in E
and F.

Column G contains the date of the next test that the pupils took,
followed by the test score and so on, repeating this pattern for about
8 tests in total.

I'd like to sort these columns so that each block of 5 columns appears
order, sorted by the date that the pupils took the test.

Is there a way of sorting column order by the values of the cells in
those columns, and is it possible to extend this to sort blocks of 5
columns by the values in the first column in each block of 5?

Many thanks for any advice!

TW