Pivot Table
 

When creating a PIVOT table, can I select more than one field at a
time to place in the table. I may have 24 months of revenue and
another 24 months of operating costs. I want to grab all 24 months of
revenue at a time a place them in the DATA area. It's very time
consuming to select one at a time.

Pivot Table
 

Excel 2007 PivotTable
One step solution with the Consolidate option.
Comparison of the two PT versions he
http://www.mediafire.com/file/z203yiwymnw/05_29_09.xlsx