How to get the invoice numbers with are assocated with unique values

hi I have an excel file here my requirement is in column B (Client) Has duplicate values

so i want to take only one unique value from column B and process the invoice nos from Column A in the application

i want to ensure that once invoice nos which have same values corresponding to the column B should get break and process the next line in Column B

i need the out with all the invoice numbers of Column A and unique value of column B

out put should be
column A column B
218456 123 EZ overs
321678
378634

hereby attaching the sample data in excel
My data.xlsx (8.3 KB)

You need to take this to the data table and using LINQ you can get the Distinct record

// Assuming your DataTable is named 'dataTable' and the column name is 'columnName'

var distinctValues = dataTable.AsEnumerable()
                             .Select(row => row[columnName]) // Project each row to the desired column value
                             .Distinct() // Get distinct values
                             .ToList(); // Convert to a List (optional)

[quote=“mukesh.singh, post:2, topic:741266”]

dataTable.AsEnumerable()
                             .Select(row => row[columnName]) // Project each row to the desired column value
                             .Distinct() // Get distinct values
                             .ToList(); // Convert to a List (optional)

[/quote]can please write this linq crearly iam not able to understand

can you please write the correct sentence