Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to merge 2 pivot tables in Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 07-01-2012
Member
 
Join Date: Dec 2011
Posts: 40
How to merge 2 pivot tables in Excel
  

Hi. I want to merge 2 pivot tables into one pivot, keeping the structure. I have 2 pivot tables with the same rows and columns and I want to keep the same format the others have. I have tried with consolidated ranges but the layout and the results are very different from the original pivots. Do you know any other solution to this problem? Thanks

Reply With Quote
  #2  
Old 07-01-2012
Member
 
Join Date: Jul 2011
Posts: 632
Re: How to merge 2 pivot tables in Excel

You just try this may it will help you to merge the two different pivot tables. So for that you just have to move the pivot table to another sheet. So to do this you have to make the use of the PivotTable Tools TAB, so this will be available when you make the selection of pivot table. With the use of the Tools TAB, you can have more than one pivot table on a worksheet.
Reply With Quote
  #3  
Old 07-01-2012
Member
 
Join Date: Jul 2011
Posts: 618
Re: How to merge 2 pivot tables in Excel

You can do this by creating the vba, so try to make the use of the vba for merging the 2 pivot tables in Excel. This is possible only with the vba.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to merge 2 pivot tables in Excel"
Thread Thread Starter Forum Replies Last Post
Combine 2 Pivot Tables into 1 Master Workbook? DANIEL 602 MS Office Support 1 04-02-2013 11:51 AM
How to merge columns of Pivot Table in single Row Heading KSHaUNiSHa MS Office Support 3 27-01-2012 07:04 PM
Filtering all pivot tables using the same criteria Kanwaljeet Windows Software 9 28-07-2011 01:08 PM
Issue while inserting pivot Tables in Excel 2003 Clemens Windows Software 3 29-04-2009 05:30 PM
Pivot Tables in Excel 2007 dixiesky Windows Software 4 10-04-2009 12:40 PM


All times are GMT +5.5. The time now is 02:13 PM.