Combining Tables

Combining tables has been notoriously difficult in Excel.

In November 2020, I wrote an article called ‘Combining Multiple Excel Tables into One’, which demonstrated several methods that were clunky, cumbersome, and inflexible. There was no alternative.

Thankfully, 17 months on and a plethora of new functions have come our way. One of them is VSTACK, which is dedicated to stacking multiple ranges (of varying sizes) on top of each other.

Be aware though that only Office Insiders on the Beta Channel can currently access it.

Syntax

VSTACK ( array1 , [array2] , … )

array1 — the first range or array to combine

[array2] — the second range or array to combine

A maximum of 254 arrays are permitted.

Example

Manchester United’s squad is broken down into tables by position: tblGoalkeepers, tblDefenders, tblMidfielders, and tblForwards. Each table name is placed in a separate array argument to return a list of the entire squad.

The benefit of using tables with VSTACK is any data added will be automatically returned in the final output.