I am trying to change hourly data to include data points for every 15
minutes.

What I have What I need
Time Data Time Data
3/1/2009 0:00 99.12 3/1/2009 0:00 99.12
3/1/2009 1:00 99.07 3/1/2009 0:15 99.12
3/1/2009 0:30 99.12
3/1/2009 0:45 99.12
So, 1) I need to create data points for time and time within my existing data
2) I need to copy data that occurs in one cell (99.12 for example b2) four
times before copying the next value (00.07 for example b3)

My data is for 9 months, too time intensive to do by hand.