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

	Month
	Week from 2019-01-06 to 2019-01-12
	2019-01-08	2019-01-09
Jay Jones
Vacation	5
Statutory holiday		8
Other paid leave

<tbody>
</tbody>

Any ideas?

Thanks,

Edu

 

[rpaulson]

I use sumifs formula