Hi friends,

I need to get data in multiple row of one column.

For example data from that format

ID Interest
1. Sports
1. Cooking
2. Movie
2. Reading

to that format

ID Interest
1. Sports,Cooking
2. Movie,Reading


I wonder that we can do that in MS...