Good Day.
I have this datatable (SourceSheet) where it consists a list of employees together with Employee ID, Employee Name, Position, and Department. I want to copy the “Employee Name”, “Position”, and “Department” from SourceSheet to WorkingSheet through Employee ID. Can I use LINQ? Or are there any other activities that can be used such as Filter DataTable?
Kindly see attached picture below for the desired output and attached file for the excel file. Thank you.
Note: The highlighted part is the desired output.
SampleExcelFile.xlsx (180.8 KB)
Best regards,
Robert Monsalud