Pondcroft13
New Member
- Joined
- May 27, 2010
- Messages
- 32
Hi All,
Here's the problem.
I have a load of raw data that I am looking to produce a pivot table from. Within this raw data a have a column, which has named individuals in it, a column stating the value (in hours) of time they are spending on a given task (eg 0.5) and then 12 columns running Jan through to December which totals the amount of time spent on that task for each month.
As people will be doing multiple tasks and there for be named in the above raw data on more than one occasion I want to produce a pivot which has the list of named resource down the left and the months running across the top and the values against each resource being the total amount of time they have spent for that given month on all tasks.
Any ideas?
Here's the problem.
I have a load of raw data that I am looking to produce a pivot table from. Within this raw data a have a column, which has named individuals in it, a column stating the value (in hours) of time they are spending on a given task (eg 0.5) and then 12 columns running Jan through to December which totals the amount of time spent on that task for each month.
As people will be doing multiple tasks and there for be named in the above raw data on more than one occasion I want to produce a pivot which has the list of named resource down the left and the months running across the top and the values against each resource being the total amount of time they have spent for that given month on all tasks.
Any ideas?