Forum Discussion

kgleng's avatar
kgleng
Copper Contributor
Dec 04, 2021

Combining data from multiple sheets into one Pivot Table

Hi,

 

Would like to find out if there's a way to combine (add up) data from multiple sheets on a same Excel file and have them displayed via a Pivot Table. The data consists of same categories with value or info which varies according to project. 

 

Attached is an example file. The Pivot Table created  in the Excel file only has the value from 1 sheet.

 

Thanks. 

BI & Data Analysis
excel
Excel on Mac
Formulas and Functions

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Dec 04, 2021

    kgleng Combining multiple tables/ranges into one pivot table is not possible in Excel for Mac. On the Windows version you could achieve it, though. And having said that, your data isn't really suited for analysis with a pivot table. It's already cross-tabulated and you include empty rows.

     

Resources