I have an excel file with emp id, name, designation, department, date, ot hours and normal hours as columns. Here are some sample data 111,John,Manager,HR,01/01/2024,0,9 111,John,Manager,HR,01/03/...
Correction. For the result, i need 3 rows for each employee (one for OT and the other Normal). Teh result should look like the following for the sample data included.
