Making Consolidated Financial Reporting Engine

Making Consolidated Financial Reporting Engine
by Using VSTACK, HSTACK

MultiNational Corp "UniGlobal" consolidates financial reports from 12 subsidiaries. Build an engine that stacks and combines data from multiple sheets/sources into unified reports.
Dataset Structure:

Consolidated Financial Reporting Engine
Function Focus:VSTACK, HSTACK
Scenario:
MultiNational Corp "UniGlobal" consolidates financial reports from 12 subsidiaries. Build an engine that stacks and combines data from multiple sheets/sources into unified reports.
Dataset Structure:
• 12 subsidiary sheets: Each with identical structure (Revenue, Expenses, Profit, Month)
• Need consolidated P&L, Balance Sheet, and Cash Flow statements
Tasks:
1.Use VSTACK() to vertically combine monthly data from all 12 subsidiaries
2.Apply HSTACK() to horizontally merge related metrics (Actual vs Budget vs Variance)
3.Build dynamic range references that automatically include new subsidiary data
4.Create summary dashboards with cross-sheet consolidation using spilled arrays
Expected Output:
Unified financial reports that auto-consolidate data from multiple sources with dynamic expansion.
Evaluation Criteria:VSTACK multi-range stacking, HSTACK horizontal merging, dynamic range handling