![how to combine 2 pivot tables in excel 2013 how to combine 2 pivot tables in excel 2013](https://www.journalofaccountancy.com/content/jofa-home/issues/2018/mar/pivot-table-enhancements-in-excel-2016/_jcr_content/contentSectionArticlePage/article/articleparsys/image_840735422.img.jpg)
One more thing, right-click on the first column again and go to Transform -> Capitalize Each Word.From delimiter window, select custom, add “-” as a delimiter, and select “Left-most delimiter”.Right click on this column and select Split Column -> By Delimiter.If you look at the data we have got an extra column here with the name of the source file.Now, we need to make little changes in our data to make it ready for a pivot table. Step 2 - Prepare Data for the Pivot Table Once you click OK and it will edit all the data from the workbooks into power query editor.(Quick Tip: Make sure to have the same worksheet name in all the workbooks). And from that window, select the worksheet in with you data in all the workbooks.From here, you’ll get a “Combine Files” window.
![how to combine 2 pivot tables in excel 2013 how to combine 2 pivot tables in excel 2013](https://danwagner.co/wp-content/uploads/2016/02/combine-sheets-into-one-starting-point.jpg)
Now, from the folder selection window, click on “Browse” and select the folder where you have all the files.Go to Data Tab -> Get Transformation -> New Query -> From File -> From Folder.
#How to combine 2 pivot tables in excel 2013 download#
You can download these files from here to follow along.Īnd make sure you have all these files in a single folder.įirst of all, we need to combine all the files into one file with power query. Here I have four different workbooks with sales data for different zones. For Excel 2016, it’s there on the Data tab and for other versions (20) you need to install the add-on. Make sure you have power query in your Excel version. Important: For this, we need to use power query. Steps to Create a Pivot Table using Data from Multiple Workbooks 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. Only after that, we can create a pivot table. 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.