Hello:
Please refer to attached sheet.
I have sample data of employee's payroll information in sheet1.
I need these data manipulated in sheet2 as below:
Column A from cell A2 onwards will be the date from Cell C3 Sheet1.
Column B is employee,
Column C is Hours and Column D is Payroll Item associated with it (Cell D4:I4 in Sheet1).
No data in Column D would mean end of data.
I have manually completed data for 2 employees.
Please let me know if any questions.
Thank you
Riz Momin
Bookmarks