Scenario:
ColA=Name ColB=Org Col C=address Col D=City. ... ColM=Email ColN=Code
John Doe Org1 Addr1 New York [email protected] 1234
John Doe Org2 Addr2 Detroit [email protected] 4123
John Doe Org1 Addr3 Dallas [email protected] 2134
Jeff Doe Org4 Addr4 Dallas [email protected] 5678
Jane Doe Org5 Addr5 New York [email protected] 9876
Jane Doe Org6 Addr6 Los Angeles [email protected] 8989
Want to get all records with same email address to new sheet with first instance of duplicate Columns a-n as a row, then each duplicate instance adding columns for certain rows like org city and code appeneded like:
ColA=Name ColB=Org Col C=address Col D=City. ... ColM=Email ColN=Code, ColO=Org2, ColP=City2, ColQ=Code2, ColR=Org3, ColS=City3, ColT=Code3...Col?=Org?,Col??=City??,Col???=Code???
Data from sample above should come out like:
John Doe Org1 Addr1 New York [email protected] 1234 Org2 Addr2 4123 Org1 Addr3 2134
Jeff Doe Org4 Addr4 Dallas [email protected] 5678
Jane Doe Org5 Addr5 New York [email protected] 9876 Org6 Addr6 8989
We do not know the max number of duplicate emails we could have that need to append to new sheet. We also want to skip rows that have no email address in them. There are other fields but no interested in duplicating those fields.
This new sheet would be used to mail merge info.
Bookmarks