If the data is in the below format
Sl. No. Student Name
1 A
1 B
2 A
2 B
2 C
3 A
3 B
3 C
3 D
I want the result in the below format
Sl. No. Student Name
1 A,B
2 A,B,C
3 A,B,C,D
Please Help
Emp ID 11-Jan-12 12-Jan-12
Total Special Tasks Total Special Tasks
499003 166.1 8 155.7 9
210009 170.2 9 178.1 7
I want to get data in the above format using the PIVOT?
Currently I have a...