Ho un db mysql in questo modo che vorrei trasformare...

codice:
id	data		periodo	valuta	metallo	valore
1	2/2/2011	Morning	USD		Gold		1337
2	2/1/2011	Evening	USD		Silver		28.32
3	2/2/2011	Morning	USD		Platinum	1830
4	2/2/2011	Morning	USD		Palladium	823
5	2/2/2011	Morning	EURO		Gold		966.529
6	2/1/2011	Evening	EURO		Silver		20.5739
7	2/2/2011	Morning	EURO		Platinum	1324.15
8	2/2/2011	Morning	EURO		Palladium	595.500
9	2/2/2011	Morning	GBP		Gold		824.291
10	2/1/2011	Evening	GBP		Silver		17.5791
11	2/2/2011	Morning	GBP		Platinum	1129.65
12	2/2/2011	Morning	GBP		Palladium	508.00

codice:
Gold		EUR			USD			GBP
Morning		966.529			1337			824.291
Evening		(se presenti)

Silver		EUR		USD		GBP
Morning	966.529	1337		824.291
Evening	(se presenti)