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!