Pulling data into a table based on date and number criteria

[JJabra]

Hi Guys,

I have a list of raw data on a separate tab to the table which consists of two columns, dates and the second column holds a number between 1 and 5.

What I want is for the table to pull data from the raw data so that everything it counts how many of each number between 1-5 there are in each week as has been manually entered below.

Upon looking online I am struggling to find similar examples to help me get started. Any help would be appreciated

Week	One	Two	Three	Four	Five
01/01/2018​	10	2	1	2	6
08/01/2018​	4	2	2	6	8
15/01/2018​	8	5	4	9	20
22/01/2018​	10	5	12	19	27
29/01/2018​	13	12	16	36	54

 

[DanteAmor]

Hello, I did not understand the example well.
You could explain again what data you have in the "raw data" sheet.
What do you have on the other sheet.
What results do you expect on the other sheet.
And please explain a couple of examples.