How to a Time planning into pivot table .

A

arnaudlalu

Hey

I need to change a time table, with names of the employees in column A and the dates in the row. The names of the projects are the values in the table but I need a pivottable to show me how much is worked per date on which project.

All help is very much appreciated !
 
A

Alex Plantema

(e-mail address removed) schreef in
I need to change a time table, with names of the employees in column
A and the dates in the row. The names of the projects are the values
in the table but I need a pivottable to show me how much is worked
per date on which project.

A pivottable cannot handle such an arrangement.
You should make a table with each type of data in only one column,
e.g. A: date, B: hours, C: employee, D: project.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top