Extracting Unique Records from List into Multiple Lists

Question

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.