June 25, 2016
I am requesting assistance in creating a pivot table from data spread out several worksheets. Basically, one pivot table summarizing data from several tables spread out in different worksheets. How can I do that? Is Power Query useful to achieve this?
I am using Microsoft Excel 2010 version 32-bit.
Any help and suggestion would be greatly appreciated it. I am very new to this so a detailed explanation would be greatly appreciated with some visuals if possible.
July 16, 2010
Power Query can help you consolidate the data into one sheet so you can use regular PivotTables as described here:
Or Power Pivot can help you by allowing you to create relationships between those tables so you can create a PivotTable from them. An example of that is here:
However, both of these methods assume your data is in a certain format and you know how to use these tools. If you want training on them then we can help you with that.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Dharan Prakash Mishra
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas