Summarise data from multiple task types to single task types

Attached is an example of a raw data report which produces data on time spent on various tasks each week by a group or people.

The report is produced each month - so there are 4 weeks of data represented on each report for each person.

There are standard tasks, which may appear on the report 4 times (once for each week), and there are general tasks which may appear one or more times in a given week, for one or more people, or not at all for anyone.
New tasks may also get added during a period.

Each task also shows the amount of time spent on it.

What I need is to consolidate all this data into a summary report which will show for each person:

- each task type they were involved with - but only ONCE i.e. 4 x "Administration" showing only as 1 x "Administration"

- show only the TOTAL amount of time associated with the multiple instances of that same task e.g. total of all "Administration" (Admin x 4 hrs plus Admin x 7 hrs, plus etc)

The sample sheet attached shows the original raw data report sheet, and a simplified (summary) report sheet reflecting what it should look like (i.e. with only unique entries per person along with their accumulated totals for each), once it has been processed.

I normally have a shot at this myself but with this one I have no idea even how to approach it let alone start it. All help appreciated.

Thanks TMS. Have played with the pivot table solution and to be frank, it is useless for this exercise. As a one off it could be ok but the process is protracted, is unreliable, not automated, and doesn't allow additional data to be added without having to rerun the entire convoluted process to have it included. Have searched on the web for solution to the inclusion of additional data problem but all seem to agree it is like I have said. Would be good if VBA could extract this data better to allow for much easier management.

with Pivot or Power Query (XL2010/2013 require PQ add-in)

Hi, I have been playing with this as time has permitted and of course it work brilliantly. As my source column has changed from Column B (Name) to Column F (Task), which entries in the code do I need to change so it references F instead of B please. All other remain as before.

Thanks. I now have included how I want it to be. New Sample file posted with the desired outcome as you request. Yes, I see now that it is more that a simple change of a column reference.
On the attached, there are two sheets, one the raw data and the other my desired outcome. The references are to columns E (Group) and column H (Time Spent). thanks again for doing this.

Hi,

according to your last attachment do the source cells color formatting must be copied to the result worksheet (slower)
or this result worksheet can be without any color (easier & faster) ?

Post #9 attachment as it is seems enough on my side, just my post #10 requires an answer …

Does sintek's proposal is what you are expecting for ?

Thanks heaps sintek. Your code is easy and produces the correct result repeatedly following changes to the source data. I don't have to modify anything for each run or do anything different. It copy-pastes into my project workbook as is and works straight off.

beyond Excel your sample sheet produces exactly the result I want, and nice table presentation as well. Attempting to run it again after changes to the source data though doesn't update the output result and I can't seem to clear the entries in order to reset it. If I paste the code, "Option Explicit" included, into a module in my project workbook it errors out "Unable to get the PivotTables property of the worksheet class". There may be a simply reason for this or I need to reset something each time I want to use it, but I don't know what that is. I still use the first code you provided me from the initial posting and that is of course brilliant work. Thanks so much for your input.