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. [excelsheet]

Filter Duplicate value into one column with out removing other column

GBK (GBK) June 4, 2020, 9:20am 2

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

Topic		Replies	Views
How to Filter Column values in Excel Sheet Studio uiautomation , activities , studio	19	1970	October 6, 2021
How to merge excel column data into single row (comma delimited) Help datatable , activities , question	4	1689	December 30, 2019
Remove Duplicates Specific Column Help datatable , activities , question	9	2587	January 17, 2020
How to add data from one excel sheet column to filtered data in another column? Help	3	1303	July 26, 2019
Filter excel data where duplicate data in each column to remain the same Help datatable , excel , studio , question	5	1132	November 8, 2020