Moving data from table row to column?

[karjoe]

--------------------------------------------------------------------------------

Hi, I don't know if this is possible but I appreciate any help in solving it.

I have table like this:

Name ID pcs Dim
Joe 123 obc Coc
Joe 123 obc Boc
Joe 123 bc Doc
Bob 323 bc Sat
Bob 323 bc Dork
Bob 323 bc Stark
Mike 423 ob ork
Mike 423 ob Dor


I am looking get a table with one line for each record and conbining the data from the last column. Something like this:

Name ID pcs Dim
Joe 123 obc Coc, Boc, Doc
Bob 323 obc Sat, Dork, Stark
Mike 423 ob ork, Dor

Thanks in advance

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[karjoe]

Great.
I also found this solution that worked as well.

http://allenbrowne.com/func-concat.html

Thank you for your help