Have a contact list in Excel. Multiple contact names and titles are listed on the same line with the main contact person. Need to have these multiple contact names/titles put on a separate line with the correct mailing address from the main contact person. Not all lines have multiple contact names and some have up to five contacts. See attached file for a samll example.
Not an Excel expert, but I am sure this can be done with a macro or some other method.