Then you could copy the data and then select the top left hand corner cell of the new layout and choose Edit, Paste Special, Transpose. There is also a 'Transpose' function that you could use to create a re-arranged layout still linked to the original. There is more detail on the transpose function here: http://www.ion.icaew.com/itcounts/18758
Thanks to you both - I'll give it a try. Kind regards, Jeremy.