Move multiple fields on multip rows into one field on one row
Posted on 2010-08-24
I have a database with contacts. Each contact can have multple roles, that is, John Smith can be President, Main Contact, Senrior Manger and Business Contanct. So, he has four roles and thus there are four rows for him. I need to colapse this into one row and his roles into one field so that it reads: President, Main Contact, Senior Manager, Business Contact
in ONE field for him. Any suggestions as I have 4,000 rows of people I need to do this for.