Convert column data into Comma seperated data

• aslamnepanagar

  SSC-Addicted

  Points: 488

  More actions

  March 14, 2014 at 3:14 am

  #396419

  Hi ,

  I have data in the below format .

  NameValuecategory

  AAA510

  BBB510

  CCC510

  DDD512

  EEE512

  FFF512

  I want the result in the below format

  NAMEValuecategory

  AAA,BBB,CCC510

  DDD,EEE,FFF5120

  I have tried stuff but all six values(AAA...FFF) are coming in one row , however i need them as per the category.

  Any help..

  Thanks

  Aslam

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  March 14, 2014 at 3:21 am

  #1697062

  Check this out:

  http://stackoverflow.com/questions/15375218/how-to-convert-columns-data-in-comma-separated-list

  HTH

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."

• aslamnepanagar

  SSC-Addicted

  Points: 488

  More actions

  March 14, 2014 at 3:29 am

  #1697065

  Thanks a lot .

  It helped. 🙂