Pivot Table Query

Hi All
  We have a new repoting requirement where we need to involve 4 revenue fields and 4 date fields in one report. Earlier we had only one date field and one revenue and it was easy to build a pivot table showing the next 6 months data.Now that we 4 new sets of fields the requirement is now chnaged.

Opportunity 1

Rev 1 100 Date 1 (Aug)
Rev 2 300 Date 2 (Aug)
Rev 3 400 Date 3 (Sep)
Rev 4 500 Date 4 (Oct)

Opportunity 2

Rev 1 100 Date 1 (Sep)
Rev 2 300 Date 2 (Sep)
Rev 3 400 Date 3 (Sep)
Rev 4 500 Date 4 (Oct)


So my final report should show the details as below


                    Revenue

Opp Name       Aug    Sep   Oct   Nov