How to replace a pivot table by formulas?

[EduPAz]

Hi,

Can someone please help me with this?

Every month I have a raw data report with these columns:
Employee, Leave type (vacation, statutory holyday, other paid leave), number of hours, week, day,month.

Instead of doing a pivot table, I would like to organize the information with formulas. For every employee, I would like to see the number of hours for each leave type by month-week-day


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Month

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Week from 2019-01-06 to 2019-01-12
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2019-01-08
[/TD]
[TD]2019-01-09
[/TD]
[/TR]
[TR]
[TD]Jay Jones
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
Vacation
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Statutory holiday
[/TD]
[TD][/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]Other paid leave
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Any ideas?

Thanks,

Edu

 

[rpaulson]

I use sumifs formula