Hello Excel(lent) users,

I am stuck with a challenge, which I wanted to share with you !

I am managing multiple projects, which are executed by multiple teams. I
want to keep track of the hours spent per team per project.

I want to get that information from the following columns:
Column A Project identification (project 1, Project 2, Project 2, etc)
Column B Name of executing team (Team 1, Team 2, Team 3, etc)
Column C Number of hours spent


The display should be in a new tab:

Project Team # of hours
PR 1 Team 1
PR 2 Team 2
PR 3 Team 3
PR 4 Team 4

Can you please help me out ?

Thank you very much for helping me out !!

Jaydubs