How to Create a Pivot Table using Multiple Files in Excel


A pivot table is one of the best ways... summarize data.

You can create a summary report within seconds

...from thousands of rows of data.

But while working with data in the real world not everything is perfect.

And today, I want to share with you a common problem which we all face.

Before I start, I want to say thanks to Raman Girdhar for his question. He has been following up with me for quite long time.

Sometimes we receive or capture our data in different workbooks and in that case creating a pivot table need some extra efforts for combining those multiple workbooks into one.

Only after that, we can create a pivot table.

So in this post, I’d like to show you a 3 steps process to create a pivot table by using data from multiple workbooks.

So let’s get started.