Calculating Costs for Each period
 

I have the other problem and I also need a help with this. It will be
very kindly just to tell me what chapter and theme I need to read.
My table is the following(it represents costs of department):
A B C D
E F G
1 Object January
February
2 Dep1 Dep2 Dep3 Dep1
Dep2 Dep3
3 Mater. 100 700
800
4 Fuel 300
700 400
5 Payroll 400 300
What I want in result:
A B C D
1 Object Dep. January February
2 Material Dep1 100
3 Material Dep 3 700
4 Material Dep 2 800
.....
The empty cells shouldn't be represent in results. Thanks for any help

Calculating Costs for Each period
 

Hi Svyatoslav
Please check below address for (P) Pivot tables

http://www.contextures.com/tiptech.html

Rgds