How to Remove Duplicate Columns in Excel and have the distinct values in the other sheet

datatable
excel
activities

#1

Hi,

Thanks in Advance


#2

@tgopalas, This one, kindly refer/search for (an existing solution).

Regards,
Dom :slight_smile:


#3

@Dominic The code didnt worked , The Duplicate values are not coming . The same Table with all the values are coming as an output

PFADates.xlsx (8.0 KB)
Add billd.xaml (9.5 KB)


#4

@tgopalas, Have you used this query ?

DataTable distinctValues = Defaultview.ToTable(true, "Column1", "Column2" )

Regards,
Dom :slight_smile:


#5

Yaa…but i didnt understand what is defaultview over ther


#6

Refer this

DataTableName =DataTableName.DefaultView.ToTable(true,"Column1", "Column2" )

Regards,
Arivu


#7

@tgopalas, Dataview - different views of the data stored in a DataTable

Reference
Select Distinct and obtain all row of it

Regards,
Dom :slight_smile: