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?

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Hourly Data[/TD]
[TD]Values[/TD]
[TD]15-Minute Data[/TD]
[TD]New Values[/TD]
[/TR]
[TR]
[TD]01/01 01:00:00[/TD]
[TD]1[/TD]
[TD]1/1/14 12:00:00 AM[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]01/01 02:00:000[/TD]
[TD]4[/TD]
[TD]1/1/14 12:15:00 AM[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]01/01 03:00:00[/TD]
[TD]0[/TD]
[TD]1/1/14 12:30:00 AM[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 12:45:00 AM[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 1:00:00 AM[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 1:15:00 AM[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 1:30:00 AM[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 1:45:00 AM[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 2:00:00 AM[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Hourly Data[/TD]
[TD]Values[/TD]
[TD]15-Minute Data[/TD]
[TD]New Values[/TD]
[/TR]
[TR]
[TD]01/01 01:00:00[/TD]
[TD]1[/TD]
[TD]1/1/14 12:00:00 AM[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]01/01 02:00:000[/TD]
[TD]4[/TD]
[TD]1/1/14 12:15:00 AM[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]01/01 03:00:00[/TD]
[TD]0[/TD]
[TD]1/1/14 12:30:00 AM[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]....cont'd[/TD]
[TD][/TD]
[TD]1/1/14 12:45:00 AM[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 1:00:00 AM[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 1:15:00 AM[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 1:30:00 AM[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 1:45:00 AM[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 2:00:00 AM[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 2:15:00 AM[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 2:30:00 AM[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1/1/14 2:45:00 AM[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]....cont'd[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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!