Excel 2007 : Pivot table with columns of monthly data

The short answer is...you can't.
Not in the format you posted, which is *aready* in a cross-tab kind of format.

You can get the kind of pivot table you want if you structure your data like this:

WBS       Name      Org      Month       Amount
5.1.1     Joe       ES       11-Oct      10
5.1.1     Joe       ES       11-Nov      11
5.1.1     Joe       ES       11-Dec      10
5.1.1     Joe       ES       12-Jan       8
5.1.1     Joe       ES       12-Feb       5
5.1.1     Joe       ES       12-Mar       3
5.1.1     Joe       ES       12-Apr      11
5.1.1     Joe       ES       12-May      15
5.1.1     Joe       ES       12-Jun      12
5.1.2     Jane      AL       11-Oct       3
5.1.2     Jane      AL       11-Nov       3
5.1.2     Jane      AL       11-Dec       5
5.1.2     Jane      AL       12-Jan       8
5.1.2     Jane      AL       12-Feb      11
5.1.2     Jane      AL       12-Mar      11
5.1.2     Jane      AL       12-Apr      11
5.1.2     Jane      AL       12-May      12
5.1.2     Jane      AL       12-Jun       4

Adding columns to identify the fiscal qtr and year might also help.

After creating a pivot table from that structure, you'll be able to group your data by fiscal qtr/yr.

Does that help?