Display all data using a pivot or any other method

I have the following sheet and with the idea to create a mail merge for each teacher workload

I want to display all of the data from the data tab in the pivot table (or some other way) where I can then create the merge

You can see Robert has a total of 27 units in the data but the pivot does not show repeated work loads showing only 17

Q

G'day,

I may not able to help you from start to finish but wanting to get the ball rolling.

Question. Mail merge is traditional MS Word, are just wanting MS Excel to do the lot ? Also the information you are distributing, how are you displaying it eg in the body of the email or as attachment in pdf, docx or xlsx format ?

Originally Posted by ratcat

G'day,

I may not able to help you from start to finish but wanting to get the ball rolling.

Question. Mail merge is traditional MS Word, are just wanting MS Excel to do the lot ? Also the information you are distributing, how are you displaying it eg in the body of the email or as attachment in pdf, docx or xlsx format ?

Happy to use word for the merge but need to bring it into the document as a name and the table

As it appears you intended to filter the pivot table to show only Robert's data, turning the range on the 'Data' sheet into a table and then filtering the 'Teacher' column (A) to show only Robert will display all of his data.
Let us know if you have any questions.