Hourly data split across new 15-minute data

[PepperBrooks]

Hi - I am hoping to divide up hourly data into 15-minute increments. The values associated with the hourly data similar should be put into quarters. The two tables below are a small sample example. The first is the data I have now and the second is that data as it should look. I just need the new values. Any ways without a macro are preferable. The final will include data for a full year. Thanks for any help/guidance. Any suggestions?

Hourly Data Values 15-Minute Data New Values 01/01 01:00:00 1 1/1/14 12:00:00 AM ? 01/01 02:00:000 4 1/1/14 12:15:00 AM ? 01/01 03:00:00 0 1/1/14 12:30:00 AM ? 1/1/14 12:45:00 AM ? 1/1/14 1:00:00 AM ? 1/1/14 1:15:00 AM ? 1/1/14 1:30:00 AM ? 1/1/14 1:45:00 AM ? 1/1/14 2:00:00 AM ? <tbody> </tbody>

<tbody>
</tbody>

Hourly Data	Values	15-Minute Data	New Values
01/01 01:00:00	1	1/1/14 12:00:00 AM	.25
01/01 02:00:000	4	1/1/14 12:15:00 AM	.25
01/01 03:00:00	0	1/1/14 12:30:00 AM	.25
....cont'd		1/1/14 12:45:00 AM	.25
		1/1/14 1:00:00 AM	1
		1/1/14 1:15:00 AM	1
		1/1/14 1:30:00 AM	1
		1/1/14 1:45:00 AM	1
		1/1/14 2:00:00 AM	0
		1/1/14 2:15:00 AM	0
		1/1/14 2:30:00 AM	0
		1/1/14 2:45:00 AM	0
		....cont'd

<tbody>
</tbody>

 

[JustynaMK]

Hi,

If your "Values" start in cell B2 and your "New Values" start in cell D2, then you can try inserting the following formula into cell D2 and drag it down:
=INDEX(B:B,ROUNDUP(ROW()/4+0.75,0))/4

 

[PepperBrooks]

Thank You!