I have a timesheet dataset containing 4 columns:
Column 1 - A workers name
Column 2 - The date they worked
Column 3 - The project they worked on
Column 4 - The hours they worked on that date, on that project.
I'm just starting to learn about the QUERY function and I hope it is possible to group the lines by two columns - Name and Date - and sum the hours, regardless of the Project, worked on each date, and end up with a table like this:
So far I've just learned how to group by a single columns values. I'm not looking for a pivot table (at least I don't think I am) because I need to be able to use the resulting table to compare with another table (attendance data) and I think it will be easier if I keep the timesheet records on a single line.
Thanks in advance.