I am relatively new to VBA so this may be something simple. I have an export from a contact database that has multiple email addresses per entry/row. I need to be able to check each row to see if there is a second email address. If there is, I would like to transpose the cell with the 2nd email along with the cell containing the salutation to a new row (with the salutation going into the same column and the 2nd email address going into the main email column). For example: Row 2 only has an entry in A2 (Salutation) & B2 (Main Email). This would be skipped. Row 3 has entries in A3, B3, & C3 (Alternate Email). A3 & C3 would then be transposed to A4 & B4.
Any help/direction would be greatly appreciated! Thank you in advance.
Any help/direction would be greatly appreciated! Thank you in advance.