values into columns

[prodadmin]

hello

how do i change values into columns with out all the the blanks ..
i have orderunits table(orderid number,value and name are varchar2).
i tried case stmts and not getting results like below,meaning i get rows multiplied,for example in here i get total 25 rows but i should get total 15 or so

"CASE WHEN  fNAME='Units' then p.value else null END AS unit_name,"

Order_ID	UNIT_NAME	DATE_NAME
30766600	1	
30766600		090909
30766600	1	
30766600		090909

any help is much appreciated

thank you

ORDER_ID	VALUE	NAME
30766600	090909	Date
30766600	090909	Date
30766600	090909	Date
30766600	090709	Date
30766600	090709	Date
30766600	090609	Date
30766600	090609	Date
30766600	090509	Date
30766600	090509	Date
30766600	090509	Date
30766600	090409	Date
30766600	090409	Date
30766600	090309	Date
30766600	1	Units
30766600	1	Units
30766600	1	Units
30766600	1	Units
30766600	1	Units
30766600	13	Units
30766600	1	Units
30766600	2	Units
30766600	1	Units
30766600	3	Units
30766600	1	Units
30766600	1	Units
		
		
		
		
orderid	date	units
30766600	090909	1
30766600	090909	1
30766600	090909	1
30766600	090709	1
30766600	090709	1
30766600	090609	13
30766600	090609	1
30766600	090509	2
30766600	090509	1
30766600	090509	3
30766600	090409	1
30766600	090409	1
30766600	090309	
30766600	090409	
30766600	090409	
30766600	090309	
30766600	090409

[PAVB]

mmmhhh... specs are not clear to me, could you please elaborate?

[prodadmin]

thanks for looking into

when i use the case stmt i get lot of blanks

CASE WHEN  fNAME='Units' then p.value else null END AS unit_name,
CASE WHEN  fNAME='Date' then p.value else null END AS date_name

like this ..

Order_ID	UNIT_NAME	DATE_NAME
30766600	1	
30766600		090909
30766600	1	
30766600		090909
30766600	2	
30766600	13

but i am looking for

Order_ID	UNIT_NAME	DATE_NAME
30766600	1	090909
30766600	2	090909
30766600	1	
30766600	13

hope this helps

thanks