We use a pivot to total up the hours worked at X rate for each employee, but to get this into the payroll software we need to use a different format. Currently we've been copy and pasting the data where it needs to go but it's a manual, time consuming and open to mistakes. Is there a way of either displaying the pivot data how the table on the right shows or a formula to extra the data into the correct format? (Please note this is an example and all the data on the test spreadsheet is fictional).
Bookmarks