Remove duplicate based on a column but only for specific rows

Hi want to remove duplicates based on a column name but only need to remove value from specific row ( where component is TRS).

Currently using this but its not giving me the outcome I want

out_FeesDataTable.AsEnumerable().GroupBy(Function(r) r.Field(Of String)(“Combined Start Date”)).Select(Function(s) s.First()).CopyToDataTable


Thanks in advance


Will do it right.

You will get a DT which has TRS, then take a distinct of that DT

@kvssnid thanks for the response.
Sorry If I didn’t explained properly. I want to compare Combined start date column and only need to remove TRS if they are duplicate.
For above pic(example) it should only remove TRS1

Compare component start date with ?

My end goals is - If TRS combined start date matches with any FLT combine start date I want to remove it.