Tool to automatically combine many large pivot table in many large Excel sheet ?
- by Sim
Hi all,
We have several Excel files that contains large pivot data table with the same structure
For example
File A
Pivot table (Field A, B, C)
File B
Pivot table (Field A, B, C)
We want to combine them into 1 pivot table (A, B, C). Just want to know which ways we can do it ?
Manual way : open a new empty sheet, copy and paste the pivot there and create the pivot again
Automatic way : is there some tool that did this ?
Thanks