+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Make a pivot table out of two separate tables.

  1. 11-28-2008, 04:40 AM #1
    brazool
    brazool is offline
    Registered User
    Join Date
    10-15-2008
    Location
    slovenia
    Posts
    42

    Make a pivot table out of two separate tables.

    Hello,

    I have two tables, each on its seperate worksheet, is it possible to make one pivot table out of them. (They contain similar data, one is for expenses and one is for income, based on quarters of a year).
    I have made two pivot tables, each for each data table. Can I maybe drag data from them to form a new pivot?

    Kind regards
    Reply With QuoteRegister To Reply
  2. 11-28-2008, 05:35 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,435
    You could try the Consolidate option when using the Pivottable wizard.

    But I think to get anything useful you will need to create 1 data table.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 12-24-2008, 10:18 PM #3
    herbds7
    herbds7 is offline
    Registered User
    Join Date
    12-20-2008
    Location
    US
    MS-Off Ver
    Excel 2007, Student Version
    Posts
    33
    Here is an example of consolidating several Tables on separate sheets:
    http://www.mediafire.com/file/xtm24d...12_19_08a.xlsx
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1