I need to create a consolidated table from a longer table. The raw data is as attached. I need to consolidate by code and date. ie: numbers of hours per code per date. A pivot table gives me the correct data but I need it in column format to feed into another workbook.
Thanks in advance.