Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 10 September 2019
  0 Replies
  2.8K Visits
0
Votes
Undo
I have a list of companies with multiple contacts in each,but I would like to create separate lists with 1 contact per company. E.g.
 
Original list
Name                   Company          Email
John                     AAA                  
David                    AAA                  
Jane                      BBB                 
Julia                      CCC                 
Craigh                  CCC                 
John                     CCC                 
 
In this case,  to have 1 unique record from each company in a separate list, I want to end up with 3 separate lists:
 
List 1
Name                   Company                            Email
John                     AAA                                      
Jane                      BBB                                     
Julia                      CCC                                     
 
List 2
Name                   Company            Email
David                    AAA                     
Craigh                  CCC                     
 
List 3
Name                   Company             Email
John                     CCC                      
 
As you can see in each list there is only 1 record for each company.
 
Any help on how to do this would be most appreciated.
There are no replies made for this post yet.