Currently, I have an Excel Spreadsheet with a list of 30,000 e-mail subjects, addressees, sender, and subject. The "To" field often contains more than one address (sometimes as many as 50). I would like to be able to normalize the data in Access2007 as follows:
Date | From | To | Subject|
1/2/09 |email@example.com |firstname.lastname@example.org; email@example.com; firstname.lastname@example.org| Lunch this week
To be converted to:
1/2/09 |email@example.com |firstname.lastname@example.org | Lunch this week
1/2/09 |email@example.com | firstname.lastname@example.org| Lunch this week
1/2/09 |email@example.com |firstname.lastname@example.org| Lunch this week
Any easy way to do this?