Could you help me insert a new column in an excel file, enhance it and eliminate duplicates from the table?Thanks

[ppr (Peter Preuss)]

@vittoria
I have for time reasons implemented with a smaller set of sample data, but it can be extended easy to more columns

configure in the default values the cols for concatenation and concat colname

data in:

data Concated with configured columnname:

Duplicates

Non Duplicates

with filter datatable and set to the remove column colname = ConCatCol you can easy remove the concat column

Find starter Help here:
DupNonDup_ByConfColList_ConcatWay.xaml (11.3 KB)