Forum Discussion
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...
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.