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                  john@aaa.com
David                    AAA                  david@aaa.com
Jane                      BBB                 jane@bbb.com
Julia                      CCC                 julia@ccc.com
Craigh                  CCC                 craig@ccc.com
John                     CCC                 john@ccc.com
 
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                                      john@aaa.com
Jane                      BBB                                     jane@bbb.com
Julia                      CCC                                     julia@ccc.com
 
List 2
Name                   Company            Email
David                    AAA                     david@aaa.com
Craigh                  CCC                     craig@ccc.com
 
List 3
Name                   Company             Email
John                     CCC                      john@ccc.com
 
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.