Hi,
I'm hoping someone can help me with this.
I am using the Excel 2013 Gantt Project Planner template to track project activities assigned to software developers on a team. In a second sheet I need a view of the same data, consolidated based on key values (developer name) with a plot of tasks for each developer shown on one row per developer, running consecutively. I'm have been trying to identify a solution using pivoting or Names and Function but have hit a wall.
The xlsx attached has a tab called "Resource Utilization" and this is a mock-up of what I am trying to achieve.
Gantt project planner2.xlsx
Any ideas would be seriously appreciated.
Thanks!
Bookmarks