+ Reply to Thread
Results 1 to 4 of 4

Creating pivot table from 2 or more tables

  1. #1
    Registered User
    Join Date
    10-22-2015
    Location
    Mexico
    MS-Off Ver
    2013
    Posts
    15

    Unhappy Creating pivot table from 2 or more tables

    Hello everyone, trying to find the solution to my problem, I found someone that has the same problem as me. Ill just paste what he wrote because I think he gave a great explaination on what he wants to do.

    I have two named tables on separate Excel worksheets in the same Excel 2010 workbook. These tables contain the exact same header items. I could get the results I want by copying the data from one of the tables, pasting it at the bottom of the other and then making a pivot table off of that.

    However, for business reasons, this is not a good option, and I instead need to create a pivot table that can produce this same result, while leaving the source data in the two separate tables.

    I have tried using the legacy PivotTable and PivotChart Wizard with multiple consolidation ranges to do this, but I ended up with fields called "Row", "Column" and "Value" instead of fields for each of my header categories.

    Here is what my data looks like. John's Deals and Sue's Deals are set up exactly the same. The Deal Manager is always John or Sue, matching the worksheet name.
    piv1.png
    And here is the kind of pivot table I want to be able to make:
    piv3.png

    I hope there is a solution for this. Thanks for reading, hope everyone have a great week!

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Creating pivot table from 2 or more tables

    Hi, I suggest you install the Power Query to Excel. Attached result.
    Attached Files Attached Files
    Last edited by stasinek; 03-23-2016 at 03:07 AM.

  3. #3
    Registered User
    Join Date
    10-22-2015
    Location
    Mexico
    MS-Off Ver
    2013
    Posts
    15

    Re: Creating pivot table from 2 or more tables

    Hello Stasinek,
    Thank you for your reply. I have a couple questions. Is PQ Table the information from Table 1 and Table 2 in just one table? The pivot table just takes the information from one table (PQ Table), not two as I wanted. The idea is to take the info from Table 1 and Table 2 into the pivot table, not from a table made from the two tables. Maybe there is something im not considering. Let me know. Thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Creating pivot table from 2 or more tables

    You are now going to be okay?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  2. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  3. Creating a pivot table from tables in 10 different workseets
    By thedizzyblonde100 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-01-2014, 08:37 AM
  4. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-12-2013, 02:28 AM
  5. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-08-2013, 10:49 PM
  6. Creating data tables from a database without using pivot tables
    By gareth.campbell in forum Excel General
    Replies: 4
    Last Post: 11-24-2010, 12:23 PM
  7. Creating Pivot Tables
    By PGalla06 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1