I have a tough one here. I have a Google form where the employees enter the hours they spent working on particular cases throughout the day. The employees often work on up to four cases a day. So there are 4 places to put the name of the case number they are working on and the hours they spent on the case number. The Google spreadsheet looks something like this.
Timestamp, User, Case number 1, Case number 1 hours, Case number 2, Case number 2 hours and so on through case 4. There are also places for other "admin" type hours they do throughout the day. Therefore all of their time each day is accounted for in some column.
I was hoping somebody could point me in the right direction on how to get these case numbers and their hours to marry up in a separate sheet so they can be calculated in a pivot table.