Need to implement the logic

[murari83.ds]

Hi

I have source date like this

for eg:

ID NEW VERSION NAME NO

100 1 V ABC 2004
100 1 V XYZ 20
100 1 V PQR P
200 1 V ABC 2005
200 1 V XYZ 30
200 1 V PQR Q

I required below out put.

ID NEW VERSION ABC XYZ PQR

100 1 V 2004 20 P
200 1 V 2005 30 Q

Can you please guide me the how to implement this senerio.

[samyamkrishna]

try vertical pivot.

serach the forum you will get it