Novice here,

I need to have an output of more than just a find/sum of two columns. If the below were on columns A,B and C

name--activity--hours
bob--change--5
bob--change--4
bob--app --4
john--app--3
john--app--5
john--change--2
bill--hardware--3
bill--hardware--1
bill--app--2
bill--app--4

What I would like to do is output how many hours of the app, change and/or hardware activity did john do but not just in the numerical sense.

Looking for John--App--8 then on the next row John--change--2 but I do not want to display a John--Hardware--0 as I do not care about 0 hours for a certain activity. I have used SumProduct to get the hourly total but I cannot find an easy way to output this with name and activity especially when the data will be wiped and renewed weekly!