Automatic Table Aggregation

%3CLINGO-SUB%20id%3D%22lingo-sub-2044452%22%20slang%3D%22en-US%22%3EAutomatic%20Table%20Aggregation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044452%22%20slang%3D%22en-US%22%3E%3CP%3EHowdy%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20we%20get%20multiple%20child%20tables%20to%20aggregate%20into%20a%20parent%20table%20both%20cleanly%20and%20automatically%20as%20child%20tables%20are%20updated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20remarket%20equipment%20for%20hospitals%2C%20so%20we%20have%20several%20inventory%20lists.%26nbsp%3B%20We%20keep%20those%20lists%20in%20tables%20on%20a%20tab%2C%20one%20table%20per%20tab.%26nbsp%3B%20A%20corporate%20body%20often%20oversees%20hospitals%2C%20and%20individuals%20at%20those%20corporate%20bodies%20often%20wish%20to%20analyze%20all%20hospitals'%20data%20at%20once.%26nbsp%3B%20We%20want%20to%20be%20able%20to%20aggregate%20several%20tables%20into%20one%20table%20automatically.%26nbsp%3B%20It%20would%20be%20helpful%20to%20find%20a%20way%20such%20that%20as%20individual%20hospital%20inventories%20are%20updated%2C%20a%20master%20list%20is%20aggregated.%26nbsp%3B%20The%20master%20list%20could%20then%20be%20published%20for%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANK%20YOU!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndyParker%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2044452%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Howdy All,

 

How do we get multiple child tables to aggregate into a parent table both cleanly and automatically as child tables are updated?

 

We remarket equipment for hospitals, so we have several inventory lists.  We keep those lists in tables on a tab, one table per tab.  A corporate body often oversees hospitals, and individuals at those corporate bodies often wish to analyze all hospitals' data at once.  We want to be able to aggregate several tables into one table automatically.  It would be helpful to find a way such that as individual hospital inventories are updated, a master list is aggregated.  The master list could then be published for use.

 

THANK YOU!

 

AndyParker

2 Replies

@AndyParker 

Power Query could be the solution if only you have Excel for Windows.

@AndyParker 

 

If you have identical tables, you can merge them into one table easily using consolidate feature in excel.

 

check these links for tutorials

https://www.happy.co.uk/blogs/how-to-use-the-data-consolidation-feature-in-excel/#:~:text=Select%20t....

 

https://corporatefinanceinstitute.com/resources/excel/study/excel-consolidate/

 

 

* If my post helped you, please click on like.