Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Pivot Table to consolidate multiple worksheets
I am attempting to use pivot tables to take rows of data from multiple
worksheets (with common column headings and layout) into one. Headings: "Proj name" "Risk Title" "Risk description" "Priority" (Proj Name is there as it seems de-normalising is a requirement for pivoting). eg Proj name Risk Title Risk description Priority Proj4 Widget problems Description 12 High Proj4 New legislation Description 13 High Proj4 Cost overrun Description 14 High I want the pivot table to be able to filter by Project Name or Priority. I've used the 'consolidate from multiple pages' and ranges based on each worksheet, including column headings. However, when I create the table, I cannot get the columns to move into the rows - they do not show up in the field list and they won't drag and drop into rows. Is there a way I can make this happen? Or is there a smarter way of achieving what I want? I've made it work when the data is in a single range on one page, but not when split into various worksheets. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to consolidate multiple worksheets into one. | Excel Discussion (Misc queries) | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
pivot table and multiple worksheets | Excel Discussion (Misc queries) | |||
Pivot Table with multiple worksheets | Excel Discussion (Misc queries) | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions |