combination of two records using key
Posted: Mon Jun 02, 2008 9:05 am
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.........
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.........