How do I filter for unique state say for example it has so many columns for each state, there are 50 state names and paste it in another excel along with other columns
@Slyvia Can you give us an example of the Excel file and the output that you expect and also could you please explain a bit more about the scenario if possible ?
You can check DataViews. They help you select distinct records from a DataTable.
DataView theView = new DataView(DT);
DataTable distinctValues = theView.ToTable(true, “Col1”, “Col2”, “Col3”, “Col4”, etc.);