Excel Question

[Ayan]

Is it possible to make a Pivot Table using multiple sources of data?

 

[AlanSidman]

Your PT needs to have a range of data that is contiguous. If you have multiple data ranges, then you would probably have to combine them before you create a PT.

 

[pecoflyer]

Perhaps see http://www.contextures.com/xlPivot08.html

 

[Awesome Wally]

You can use Power Pivot to weave together data from multiple sources. Have a look here and/or search Google for more tips. http://chandoo.org/wp/2013/01/21/introduction-to-power-pivot/