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

Help Studio
1

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)

2

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)
3

[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

4

can you please write the correct sentence