Combining Rows in a report Query - Not sure if I need a Pivot or VBA or something else

[lassykk]

Hi,

Really hope someone can help with my query.

I need to create a dynamic report (that changes when the data changes) to reflect a staff member's project allocation over a period of time.

I've attached an excel spreadsheet showing what I am trying to achieve. I have created what I am trying to achieve manually but I have over 100 staff all on different projects and I don't want to have to manually create the report for each staff member.

For those who haven't opened the attachment:

I have multiple rows for each staff member based on the project they are on and I need to combine this into one row showing the person only once and the project they are working on in that month.

I'm not explaining this well but I've attached a screenshot of what I'm trying to achieve and also a sample excel file.

Happy to do this via VBA, a pivot or anything you suggest but this has me stumped.

Thanks in advance

\1