data sheet that needs to be sorted

[michielvdputte]

Hi there,

Not very extremely good with excel, therefore this question.

I have a Attachment 792289 (see attachment)

- i have the project titles
- i have different activities possible

Now i generate anoter table that puts the total activity time (devided by different types of activities) so i can see
- the total activity time per project
- the total time of different activities.

i hope it is clear in this way and anyone is possible to help me
uren.csv
with kind regards,

Michiel

Attachment 792253

Met vriendelijke groet,

Michiel van de Putte

[oeldere]

With a pivot table.


I made a table of your data

insert => table.


After that a pivot table of the table.

Insert => pivot table.


See the attached file.