0
Undo
Votes
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.
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.