Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidate data in pivot table
I would like to consolidate the data from several worksheets into one pivot
table. All of the worksheets have the same number of columns with the same column labels but each table has a different number of rows with various entries in column 1 of each row. Column 1 contains peoples names and the people involved can change each time the data is collected. The names may repeat in one worksheet and they may or may not appear on every worksheet. Ultimately I would like to create a chart that shows the trend for a person from month to month. -- Vickie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidate data in pivot table
Hi,
There is an option on the first step of the Pivot Table Wizard that allows you to use multiple ranges for consolidation. You should check this out first, if it works great. The second option is to copy the data from each sheet into a master sheet and build the pivot table from that. Its an easy solution, but it may not be appropriate in you case. The third option is to use a UNION query to create the cache, this is quite challenging. But if the other techniques don't meet your need, post back. -- Thanks, Shane Devenshire "vickie s" wrote: I would like to consolidate the data from several worksheets into one pivot table. All of the worksheets have the same number of columns with the same column labels but each table has a different number of rows with various entries in column 1 of each row. Column 1 contains peoples names and the people involved can change each time the data is collected. The names may repeat in one worksheet and they may or may not appear on every worksheet. Ultimately I would like to create a chart that shows the trend for a person from month to month. -- Vickie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate Pivot table from multiple files | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Using Pivot Table to consolidate multiple worksheets | Excel Discussion (Misc queries) | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions |