Filter Duplicate value into one column with out removing other column

Hi, can anybody help me to copy duplicate values, first filter the column “Customer ID” if found any duplicate than don’t remove other columns values like “Current balance” and “Charged off”, merge them into one column with a comma or | because other values have different data.

@chandiomasroor636 - welcome to community!
please check the below link having a sample solution… it might helpful…