I’m looking to extract rows from a datatable where a specific column has the same value.
I have a datatable where i want to extract all rows were the value in “Column 1” is the same. So for the below example, there are 3 unique values in “Column 1”, meaning there will be 3 different extracts. These different extracts are to be populated into seperate excel sheets.
What is the best way to achieve this?