Inserting Blank Rows Between Multiple Rows of Existing Data in Excel

So today I was faced with a problem that I hadn't had to solve for before.  I needed to create a schedule for an entire year with 8 rows for each day to account for 8 hrs in each of those days.  I only wanted weekdays since it's a work schedule.  So to get the dates for 2014 of just the weekdays was easy enough in Excel 2010.  Just start with 1/1/2014, a Wednesday, fill 261 rows down and then in the little fill options screen select  "Fill Weekdays".  Boom, weekdays only.  But the next part of my problem is that I need the weekday but then each weekday needs room for 8 hours each.  What I did was added a column next to my list of dates and numbered them from 1 - 261.  I then took that column and copied it's contents and pasted it below itself 8 times.  So now I have the sequence of 1 - 261 repeated 8 times.  The first sequence has my weekday dates next to it but the other 8 have a blank cell.  Now, if I then select the entire range and turn on AutoFilter and sort this smallest to largest based on the sequence field I magically have inserted 8 rows between each row with a date.