Divide values of periods over months (for example)

[Bozo the C]

Hello a good day!
I would like to know if there's a smart way to divide values for surtain ID's over months.


This would be possible using the start and ending date.


With SQL you can place those values in columns.


Is there an easy way with Excel?


Could you please tell me what the easiest way would be with Excel?


Given is the first table. The second table should be the result of the action.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2		ID	Start	End	Value
3		1	12-11-2016	3-31-2017	5
4		1	4-1-2017		6
5		2	2-1-2017		5
6		3	5-1-2016	1-31-2017	5
7		3	2-1-2017	11-30-2017	6
8		3	12-1-2017		7
9		4	10-1-2016	2-28-2017	5
10		4	3-1-2017	5-31-2017	6
11		4	6-1-2017		7
12		5	4-1-2017	6-30-2017	5
13
14
15
16			Value
17		ID	January	February	March	April	May	June	July	August	September	October	November	December
18		1	5	5	5	6	6	6	6	6
19		2	-	5	5	5	5	5	5	5
20		3	5	6	6	6	6	6	6	6	6	6	6	7
21		4	5	5	6	6	6	7	7	7	7	7	7	7
22		5	-	-	-	5	5	5	-	-	-	-	-	-

<tbody>
</tbody>

 

[Bozo the C]

Anybody?

Perhaps i'm unclear? Please let me know!