amazing problem

[slimdave]

Try this:

Select id, mon1, mon2 From MyTable
UNION
Select id, mon2, mon3 From MyTable
UNION
Select id, mon3, mon4 From MyTable
UNION
Select id, mon4, mon5 From MyTable
Order by 1,2,3; 

UNION ALL, surely?