Excel 2003 Pivot table: creating Fields from Consolidated muti ran
 

I am trying to consolidate 2 tabs in excel and create a pivot table of the
data. I want to have multiple tiers of "row" data which categorize the
taxonomy of the data I am trying to rollup.

I am working with a action item database and each issue is categorized in 3
cascading ways and has a wasted time value associated with it. (Ex.
Process1-sub process- sub-sub-process , and a wasted time of #hrs for each
entry.)

If i do not consolidate multiple ranges and let excel pick the fields I have
a large number of fields (with meaningful names) I can place in the
appropriate places. When I consolidate and pivot, I am stuck with 4 fields
(row, col, value, page) which are only some of the data I would like to roll
up in the table.