I have a huge data sheet with thousands of contacts with multiple email addresses. I'm trying to copy each unique email address and create a new record with the same contact name but each with a unique email to it resulting in 3 columns: First Name | Last Name | Email instead of first name | last name | email 1 | email 2 | email 3| etc
an example of what I'm trying to accomplish in this photo:
sample of what I'm trying to accomplish:
I actually found a workaround for this...
I cut the columns D, E over to the right two columns each and then filled int he blanks with the first and last name so I ended up with 9 columns
first name|lastname|email1|first name|Last Name| email2| First name| Last Name | Email 3
Then I cut and pasted them under each other, used a filter to sort and deleted the rows with blanks and ended up with
first name|last name|email
and ended up with separate records, of multiple instances of the same name but with a unique email address for uploading into my ESP.
it works! problem solved!
Convert or transpose excel report (horizontal) to tabular (vertical) format for importing per Ron Rosenfeld and Emily The steps are shown below and super easy. Just replace
(Style with First) (Color with Last) (SO - Email1) (S2 - Email2) (S4 - Email3)
