Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parse column values 1

Status
Not open for further replies.

humpydumpy2000

IS-IT--Management
Aug 18, 2016
30
PH
Hola a todos,

Does anyone knows hows to parse column values like this way:

I have some table where values are:
ID Category Name
1 A Apple
2 A Orange
3 A Mango
4 B Peanut
5 B Cashew
6 C Beans


My question is how I am going to display each category and concatenate all values for each category in 1 value
like:
Category Values
A Apple, Orange, Mango
B Peanut, Cashew
C Beans


Muchas Gracias!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top