PL/SQL transforming table output ?????

Hi,

i have the follwoing table:

	column1 column2
        -------	-------
Row1	x1	 10
Row2	x2       20
Row3	x3	 20
Row4    x1       20
Row5    x2       10
Row6    x3       10
.       .         .

what i need to do is to get my output in the follwoing format:

	x1	x2	x3
	--	--	--
Row1	10	20      20
Row2	20	10	10

any help would be appreciated!

Thanks Received on Wed Mar 01 1995 - 19:52:50 CET