RadGrid Merge the the rows

[binny]

I have the following scenario

Id Name UniqueId Country   City

1  xyz    abc123     UK        London

2 xyz      abc123    UK     Leeds

3 nop     tty123     USA         Dallas

4 nop     tty123     USA        Boston

5 bob     ght334   Canada   Ottawa

6 smith  ryh123    USA

7 smith ryh123     Canada

 

I want to merge the rows and show the list and represent it in the Radgrid with filtering and sorting

1 xyz    abc123     UK        London, Leeds
2 nop     tty123     USA         Dallas, Boston
3 bob     ght334   Canada   Ottawa

4 smith  ryh123    USA ,Canada