Hi, I have Situation Like this : [image] I need to apply filter to the parent column which contains NA values i.e i want to apply filter on the second column not the first, When I am using Filter Datatable it says Column Parent already belongs to the data table. How to tackle This ?

Hi @Ishan_Shelke Do check out this post also [image] Rename Duplicate Column in an excel Forum Hi @deepaksvg99 One approach could be this Read the excel without the headers Store the values of row(0) in a string array ColArr = dt_Data.Rows(0).ItemArray.Select(…

How to filter Columns with same column Name

Help Robot

ppr (Peter Preuss) July 6, 2022, 8:28am 4

As an alternate for handling Duplicated Col Names have a look here:

Topic		Replies	Views
Remove Duplicate rows based on primary key Studio	5	1038	April 20, 2020
How to filter a column in Excel Help robot , studio	10	9818	November 7, 2019
Read Range: A column named 'X' already belongs to this DataTable. How to bypass Learning Hub	2	7859	June 22, 2020
How to rearrange columns in Excel and duplicate one of them? Help datatable , excel , activities , question	1	936	November 20, 2020
Check column name if found header same Activities excel , activities , question	5	1588	March 7, 2022

How to filter Columns with same column Name

Related topics