combination of two records using key

[edward_m]

I have a requirement to comibe records to one record based on their key

Example..

NO Name
1 STR
1 M
2 PMR
2 L
3 KYM
3 Z

I want to convert the above into the following output

NO Name1 Name2
1 STR M
2 PMR L
3 KYM Z

Could you please through some ideas how to get the desired output from the above.........

[sachin1]

hello friend below link is good example, it will help you

viewtopic.php?t=97681&highlight=vertical+pivot