Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge 2 datasheets into single Pivot Table.
I use Excel 2003.
In a single Excel File, I have similar data in 2 different worksheets & I need to combine them in a single Pivot Table. I cannot paste them one below the other as the data is more than 65536 lines, so I split them into 2 sheets. Is there a way to get these data in a single Pivot Table.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge 2 datasheets into single Pivot Table.
Hi,
1. I prefer the concept of storing the data in Access and connecting an Excel pivot table to the data. 2. Also a nice solution would be to upgrade to Excel 2007 which allows 1,048,000+ rows per sheet. 3. Depending on exactly what you are trying to do and your data layout you could try the Data, PivotTable and PivotChart Report command and choose Multiple Consolidate Ranges. 4. The most difficult would be to use a Union query. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "free_ur_mind" wrote: I use Excel 2003. In a single Excel File, I have similar data in 2 different worksheets & I need to combine them in a single Pivot Table. I cannot paste them one below the other as the data is more than 65536 lines, so I split them into 2 sheets. Is there a way to get these data in a single Pivot Table.... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge 2 datasheets into single Pivot Table.
Hi,
Look into Debra Web http://www.contextures.com/xlPivot08.html if this helps please click yes, thanks "free_ur_mind" wrote: I use Excel 2003. In a single Excel File, I have similar data in 2 different worksheets & I need to combine them in a single Pivot Table. I cannot paste them one below the other as the data is more than 65536 lines, so I split them into 2 sheets. Is there a way to get these data in a single Pivot Table.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart Table - Single Source Field Name | Excel Discussion (Misc queries) | |||
Single Pivot Table 4 Multiple Sheets? | Excel Discussion (Misc queries) | |||
Single Pivot table for similar Multiple sheets? | Excel Discussion (Misc queries) | |||
pivot table single choice | Excel Discussion (Misc queries) | |||
create single page for each entry on top 10 pivot table | Excel Discussion (Misc queries) |