How to combine duplicated rows by conditions?

[LeiCheng]

Hi, I am meeting such a problem that how to combine the duplicated rows with condition. When meeting some cells are duplicated, the these rows will be changed into one row, and a cell will contain the all the difference in one.Can anybody have any idea? Thanks.

[Jonathan-Sherman · Accepted solution]

Hi @LeiCheng,

This is a perfect example of the summarise tool. You can group by Name, Born, Location (and Company, not sure whether you wanted to include that, but i have for now). Then concatenate on Position with a seperator of comma plus a space ", "

I've also renamed the column names from the default "group_by_fieldname" to the original field name in the summarise tool.

Input data:

Final output with summarise:

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.

Regards,

Jonathan

[paulfound]

Hi @LeiCheng 

If I understand correctly you have joined, some data sets, now you want the duplicate values to merge into one on a certain element and concatenate the different values.