Hello,
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.
Singhg
Hi Singhg,
Power Query can help you consolidate the data into one sheet so you can use regular PivotTables as described here:
https://www.myonlinetraininghub.com/combine-excel-worksheets-with-power-query
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:
https://www.myonlinetraininghub.com/power-pivot-does-vlookup
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.
Mynda