How do I filter for unique state and paste it in another excel along with other columns

Help Studio
, ,
1

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

2

@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 ?

3

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.);