Forum Discussion
Pivot table data sources
Hello, I would like to create a pivot table from an excel workbook containing various worksheets. All the worksheets have the same headers. The data in the worksheets is organized by month - one wor...
NikolinoDE these tutorials are helpful thank you. the columns in my worksheets are the same the rows are different as the values are unique (patients for example), is there one approach that is better suited for this format? Thanks
You can use either of these two approaches:
- Combine all data into one worksheet before creating a pivot table.
- Create a pivot table for each worksheet and then combine them using a formula.
If I may recommend you, add a file (without sensitive data) and explain your project step by step based on this file. In addition, information about the digital environment would be very helpful. Digital environment means information about the Excel version, operating system, storage medium, etc.
Thank you for your patience and understanding