How to get output as unique rows by comparing two columns using LINQ query

Hi Gokul. Thanks for the valuable reply.

If I take any of the single column name in the query it is missing some unique values again. I have edited my post in detail. Can you please check once and help me on this please @Gokul001