Concatenate Data in same column

[jabmod]

I have a table 2 columns (Object and Weight) with data like below:

Object Weight(lb)
table 5
Chair 6
Computer 3
Computer 5
TV 20
TV 15
Radio 10
Computer 10

Question: I would like to create a new table with one column that would join the above two columns like below

Object
table 5
Chair 6
Computer 3, 5, 10
TV 20, 15
Radio 10


Thanks for your help in advance.

 

[gmmastros]

thread183-1159740

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[fredericofonseca]

thread183-906921

its always useful to search the threads for a solution before posting a question

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com