Need help. Can someone help me on this.
I have loaded an excel to a data table. Want to identify duplicate and non-duplicated header columns.
below is my sample;
I want to compare the below highlighted data from a data table, and put into two different tables with all other data. one with duplicate heading and the other one with non-duplicates
Duplicates needs to be checked on the highlighted. not with number of columns but the value in the highlighted column as I have given. What I meant by dynamic is if we get two excel files one file can have AA,AB,AC in highlighted place and in another file can have AA,AB,AC,AD,AC etc
So our solution should work for any file that we receive