Hi Team , I have the below collection in C# and I need the below expected result. Could you please what is the best way to achieve this in linq ?
EffectiveDate EmployeeID Department Addresss OfficeLocation
3-01-2021 10 0000 null Bangalore
2-01-2021 10 9121 Mumbai null
1-01-2021 10 9123 9121 Mumbai
30-12-2020 10 null null null
29-12-2020 10 null null Bangalore
28-12-2020 10 3121 Kolkatta Bangalore
Expected Result
EffectiveDate EmployeeID Department Addresss OfficeLocation
3-01-2021 10 0000 Mumbai Bangalore
2-01-2021 10 9121 Mumbai Mumbai
1-01-2021 10 9123 9121 Mumbai
30-12-2020 10 3121 Kolkatta Bangalore
29-12-2020 10 3121 Kolkatta Bangalore
28-12-2020 10 3121 Kolkatta Bangalore