How to combine cells together by match seperated by comma

**rajamdade** · 06-05-2019, 01:10 AM

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!

**Pepe Le Mokko** · 06-05-2019, 03:12 AM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.