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.