Results 1 to 3 of 3

Thread: How to merge 2 pivot tables in Excel

  1. #1
    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

  2. #2
    Join Date
    Jul 2011
    Posts
    642

    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.

  3. #3
    Join Date
    Jul 2011
    Posts
    627

    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.

Similar Threads

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •