pivot showing monthly columns for elapsed time

[scotmaurer]

I have scheduling data that has a numerous items along with the start date and estimated hours to complete (ETC). The problem comes when the ETC runs across months. I want to show the hours associated with each month in a pivot table without having to duplicate the entire row and show start date, end date & hours for each month associated with the task. I have set it up with this format to do now since I have not found a way to get the months .

data shows:
task1,hoursA,start date1, end date1
task1,hoursB,start date2, end date2
task2,hoursC,start date1, end date1
. . .

pivot shows:
sum hours
task month1 month2
task1 hoursA hourB
task2 hoursC
. . .

For easier maintenance, I would like to have the data show:
task1,hours,startdate
. . .

then have the pivot recognize that the hours cross over months.

Any ideas or alternatives would be appreciated!

Thanks!