How to combine duplicated rows by conditions?

Question

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.

testing.xlsx

Jonathan-Sherman · Accepted Answer

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