Merging duplicate values in a single row sql but keeping other information for crystal report : I have a sql query and i got the following result
[SQL Query Result][1]


But i want to merge the MemberName column for same members but the values in other columns will remain same  so i can make the crystal report properly. I want to make my report in the following format
[Desired Result][2]

btw, sorry for using images & TIA.
 


  [1]: https://i.stack.imgur.com/DcfC1.png
  [2]: https://i.stack.imgur.com/n7NOY.png
