Combine one column value if duplicate row ( not delete duplicate row )

Hi everyone.

I have a table as below. I want to check it they have same value at A col “item”… then it will combine values at C col “Location” and return value into the D col.

How to do that??? … and with LinQ is better.

Thanks in advance!


I don’t think it is possible to do it entirely with LINQ, especially since you have to assign the new value to the status column.

But you can use the GroupBy() LINQ function to make this easier. See attached for an example. (30.4 KB)

1 Like

Thanks you very much!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.