Recommended Pivot Table

Copper Contributor

Hi, I wanted to ask if there is any option to create my own format of Pivot table that I will be able to click on it and get a relevant table based on my needs..
I make the same table everyday but with another database ( in another workbook as well)..
For example - I want my pivot table to look like this every time I need it


How can I do it automatically?

1 Reply



Not sure I'm following all the details of what you're describing, but I wanted to suggest that you look into using some of the dynamic array functions--notably UNIQUE, FILTER and SORT--which can be used to create the same kind of display as that done "automatically" by the Pivot Table, but far more customized.