how to make a single pivot table from multiple identically formated sources

David Berg 20 Reputation points
2023-04-21T18:03:08.7766667+00:00

I have a workbook with several worksheets in which the data is arranged the same, ie, rows with identical columns. I can easily make a pivot table from one of these. If I combine all the data on a single worksheet, it is quite large and excel repeatedly hangs or crashes. So I want to make a single pivot table from all of them.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,553 questions
{count} votes

Accepted answer
  1. Emi Zhang-MSFT 22,636 Reputation points Microsoft Vendor
    2023-04-24T06:43:41.43+00:00

    Hi @David Berg,

    Did all tables have the same title? I created a sample about your requirement: User's image

    Go to Data- From Table/Range import all tables into Power Query, and then Append Queries as New: User's image

    User's image

    Then you can based on the new Table to created the PivotTable in Excel: User's image

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful