Data in different cells into one cell

[phani]

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

 

[NARAYANK991]

Hi ,


A similar question was asked and answered some days back :


http://chandoo.org/forums/topic/how-to-do-a-formula-like-subtotal-but-with-text


Narayan