I have this datatable (Sheet2) where it consists a list of employees together with Employee ID, Employee Name, Position, Hours Rendered, and assigned Project Number. I want to put the “Hours Rendered” per employee from Sheet2 to column “Jun-22” in Sheet3. I also want to copy and put the employees together with other columns mentioned above from Sheet2 to Sheet3 that are not yet present in Sheet3. Can I use LINQ? Or are there any other activities that can be used?
Note: The highlighted rows are the employees from Sheet2 that are not yet added to Sheet3.
Kindly see attached picture below for the desired output and attached file for the excel file. Thank you.
SampleExcel.xlsx (9.5 KB)