Forum

Notifications
Clear all

Power Query

2 Posts
2 Users
0 Reactions
145 Views
(@singhg)
Posts: 1
New Member
Topic starter
 

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.

 

SinghgConfused

 
Posted : 25/06/2016 1:34 pm
(@mynda)
Posts: 4766
Member Admin
 

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

 
Posted : 25/06/2016 7:33 pm
Share: