Hi all,
I have a combined Excel file of a list of email addresses with a column containing a number identifier (where the list was exported from).
When there is a duplicate email I would like to combine the numbers.
How it is:
FirstName | Lastname | Company | Email | SenderID
John Smith xyz js@xyz.com 2
John Smith xyz js@xyz.com 3
What I am looking for:
FirstName | Lastname | Company | Email | SenderID
John Smith xyz js@xyz.com 23
Ive searched for the utility to do this, but cant seem to find it.
I could go back to the initial lists before they were merged.
This is urgent.
Thanks much!
Wylie