I can’t get my head wrapped around this. I have a table with several fields but I want to create a new table, merging the email addresses into a new field (separated with a semi-colon)
Starting Table (Fields: Unit and Email)
Unit A john.doe@gmail.com
Unit A bill.smith@gmail.com
Unit A george.jones@gmail.com
Unit B Allen.jackson@gmail.com
Unit B Richard.nixon@gmail.com
Unit C Ronald.reagan@gmail.com
New Table (Fields: Unit and Email)
Unit A john.doe@gmailcom; bill.smith@gmail.com; george.jones@gmail.com
Unit B Allen.jackson@gmail.com; Richard.nixon@gmail.com
Unit C Ronald.reagan@gmail.com
Any help would be appreciated