Combining Tables in Excel: VSTACK, HSTACK, Lookups, GROUPBY & Reconciliation
Turn monthly files and regional exports into one live table: VSTACK and DROP for stacking, HSTACK for a source column, XLOOKUP to merge columns, missing records in both directions, UNIQUE de-duplication, GROUPBY summaries, reconciliations with a formula rule and a combined dashboard chart: 8 hands-on labs, graded instantly.
The first lesson is free — no account needed.
About this course
An Excel course on combining tables that turns the monthly files and regional exports of one fictional company, Brightline Office Supply, into one live table, for analysts, accountants, controllers and anyone who still copies and pastes sheets together. You stack the North, South and West exports with VSTACK and DROP so only one header row is left, tag every row with its month with HSTACK, add the customer region and unit price from master tables with XLOOKUP and find the revenue without a matching customer, list the records missing on either side of an order and invoice comparison with FILTER, remove duplicate rows with UNIQUE, summarise by region with GROUPBY and PERCENTOF and rebuild it with SUMIFS for older Excel, reconcile CRM and ledger totals with a tolerance, and build a quarter dashboard with a chart. Fictional company and data. The first lab is free.
Lessons
- Stacking Regional Exports with VSTACK and DROPFree
- Monthly Files into One Table: a Source Column with HSTACK Pro
- Merging Columns from Other Tables with XLOOKUP Pro
- Matching Keys: Missing Records in Both Directions Pro
- De-duplicating Combined Rows with UNIQUE Pro
- Summarising the Combined Table with GROUPBY Pro
- Reconciling Totals between Two Sources Pro
- Capstone: a Combined Quarter Dashboard with a Chart Pro