Kindly help me to get result as in column D and E, when given data as in column A and B
A B C D E Species list Species group Group name Combine groups A001|Species_1 Species_1 Species_1 A001|Species_1,A002|Species_1,A007|Species_1 A002|Species_1 Species_1 Species_2 A004|Species_2,A008|Species_2,A005|Species_2 A007|Species_1 Species_1 Species_3 A003|Species_3,A009|Species_3,A013|Species_3 A004|Species_2 Species_2 A008|Species_2 Species_2 A005|Species_2 Species_2 A003|Species_3 Species_3 A009|Species_3 Species_3 A013|Species_3 Species_3
Thanks in advance!
Bookmarks