Swapping round rows & columns

In the normal order (i.e. rows & columns as per the database).

id	date	tomScore	dickScore	harryScore
1	2010-07-01	35	31	45
2	2010-08-01	56	64	49
3	2010-09-01	44	65	43

Now the 1st column shows the field names & each other column shows a record

id	1	2	3
date	2010-07-01	2010-08-01	2010-09-01
tomScore	35	56	44
dickScore	31	64	65
harryScore	45	49	43