Need Linq for Find duplicate data and merge the corresponding data of other cell

your excel is different to the provided sample from above, therefore the grouping goes different

what are all the columns you want to group by the data?

Also have a look here: