+ Reply to Thread
Results 1 to 3 of 3

Creating Pivot Table from Multiple Sheets with Identical Headers?

  1. #1
    Registered User
    Join Date
    05-07-2019
    Location
    maryland
    MS-Off Ver
    365 ProPlus, Version 1904
    Posts
    6

    Creating Pivot Table from Multiple Sheets with Identical Headers?

    I want to create a pivot table that pulls data from two tabs on a spreadsheet. Both tabs have the exact same header rows; one is just the continuation of the other. Normally, I could just combine them on one tab but one of the tabs has over 1 million rows so combining data from the other tab would make it too large so it has to be split. I've looked all over and can't seem to figure out how to create a pivot table with 2 tabs like this. Everything I've found is for multiple tabs with different headers but since these have the same headers, I can't figure it out. Can anyone help?

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070

    Re: Creating Pivot Table from Multiple Sheets with Identical Headers?

    Hi,

    Take a look at this brilliant explanation :

    https://www.contextures.com/xlpivot08.html
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: Creating Pivot Table from Multiple Sheets with Identical Headers?

    An alternative solution is to bring your two tables into Power Pivot and join them. Then create your pivot table.

    https://www.myexcelonline.com/blog/l...s-power-pivot/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. MERGE and SORT several sheets with identical headers.
    By 4ero in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2020, 12:01 PM
  2. Replies: 1
    Last Post: 10-28-2019, 06:32 AM
  3. Replies: 2
    Last Post: 05-09-2017, 04:55 PM
  4. Creating a Pivot table from data with Sub columns/headers
    By taketad in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-26-2016, 11:20 PM
  5. Creating pivot table from multiple ranges (sheets)
    By Kestis in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 09-26-2016, 06:20 AM
  6. Making a pivot from multiple sheets with the same headers
    By thedon_1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-03-2014, 09:45 AM
  7. Creating Pivot Table from Multiple Sheets
    By Cortlyn in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-15-2014, 06:17 PM

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