Extracting Unique Records from List into Multiple Lists

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.