We use a spreadsheet to keep track of hours (or work units) for a individual per day based on a contract and code. I've attached an "Example" spreadsheet. Each individual has an identical spreadsheet ("Entry" sheet) and tracks the hours or units per day. I would to transform the data entered by the user to a more tabular form ("Data" sheet) so I can combine the information and manipulate in a pivot table (similar to the "Pivot" sheet). I can't get my head around the best way grab the entry data and put it into the data table without moving a lot of null or empty values -- open to suggestions or a push in the right direction. It is a pain to cut and paste or hand enter the data to roll it all up.

Thank you!Example.xls