Forum Discussion
krountree
Aug 02, 2021Copper Contributor
Averaging across multiple tables with various criteria
Hello, I'm looking for help on two problems right now that are intertwined. First, I have data for many devices stored in a single sheet called "Summary". The data are imported into their res...
SergeiBaklan
Aug 02, 2021Diamond Contributor
Power Query will be easier solution if you consider such option. Let assume you have few dozens of tables having same structure and names are from "Table..".
You may query Excel.CurrentWorkbook(), select all names begins from "Table", fill down the tests and pivot result.
With new data that's only refresh.