Pivot Tables in Word for Mac

You've had a lot of views over the time your inquiry has been up, no responses. It may have something to do with the reference in your title to "Pivot Tables in Word" but also might just be that none of us knows exactly what to suggest.

Would you be willing to post a sample of the original data with a description of what you're asking the Pivot Tables to do? You might be able to simply drag and drop to the area below the text box for replying. If that doesn't work, post the file on OneDrive or GoogleDrive and paste a link here.

All that aside, there have been developed over recent years some "Dynamic Array" functions that are able to replicate the kind of summary layout that Pivot Tables provide, and to do so without requiring "data refresh".

Here's a link to a set of descriptions of those Dynamic Array functions if you (like me) would just as soon noodle though this on your own.