+ Reply to Thread
Results 1 to 3 of 3

How can I combine multiple tables into one pivot table?

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    Earth
    MS-Off Ver
    Excel 2010
    Posts
    15

    How can I combine multiple tables into one pivot table?

    Monthly Sales Peformance Report.xlsx

    I have attached a sample of the worksheet I am trying to configure. I have 10 tables that have the exact same column headings for each sales region. I am trying to figure out how to set them up like a pivot table, so that you don't have to scroll down to view the tables. I want to have a drop down box where you can select the region, and the table will show up. Kind of like in pivot tables where you select a certain item, and the table shows that items data. I don't even know if this is possible, but would appreciate some help.

  2. #2
    Registered User
    Join Date
    09-14-2010
    Location
    San Diego, US
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: How can I combine multiple tables into one pivot table?

    bump...yeah I'd be curious on how to do this as well I have a report that has 4 years worth of data split up into quarters

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How can I combine multiple tables into one pivot table?

    Re-arange your data, then you get what you want.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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