Combining Two Pivot Table Columns into one Sum

Hello everyone,

Is it possible to combine two columns of data into one column with sums in a pivot table?

I attached a sample spreadsheet of what I'm trying to accomplish. On a daily basis, we track tasks that people are doing. I would like a pivot table that tracks how much time each individual spends on each activity (a sum of all the days). For example, Anna spent 4 hours playing outside total (combining Activity 1 and Activity 2), and 6 hours total on a museum visit.

Thank you for your help in advance.

Anna

Hi Olly,

Wow, this is super impressive, and I will definitely try to make this work with my data.

However, I was hoping for a more simple solution, since a few of my colleagues will also be using this spreadsheet on a regular basis. Are there any other workarounds that may make this a bit more simple?

Thank you again!

Anna

Thanks again, Olly! I did restructure the source data to have a column for each activity, and the number of hours for the duration to be written in the row based on day and person's name.