Converting Data Into a Matrix Form

[gundalav]

Hi all,

Is there an automatic way to convert such data

x y z
1 1 0.191850393
1 2 0.343870875
1 3 0.373216464
1 4 0.439175393
2 1 0.021883536
2 2 0.136193589
2 3 0.146259946
2 4 0.181633304

into

		                x	
		       1	                2
	1	0.191850393	0.021883536
y	2	0.343870875	0.136193589
	3	0.373216464	0.146259946
	4	0.439175393	0.181633304

I need to do this automatically since there are thousand
of lines in original format.

Regards,
G.V.

[reggie1000]

hi gundalav,

use sumproduct, i have attached a sample to show you, adjust the ranges as necessary.

thanks reg