Forum Discussion

iamscorefield's avatar
iamscorefield
Copper Contributor
Apr 10, 2023

Merge pivot tables.

Hello Everyone,  I am working on an extensive dataset with separate data sets for each month, the business task is to analyze and visualize the result in a year view. I have created, copied, and pasted all the 12 months' pivot tables into a new worksheet in Excel named "full_year. I need help on how to merge them together, so I can conduct a year view of analysis and visualization.

 

Please help.

Thank you

Resources