Reduce function in excel to stack tables with VSTACK
How to use the Reduce function in excel with VSTACK to stack tables
This video explores how to replicate Power Query in Excel by having a list of tables and combining them or stacking them vertically using formulas
Link to Excel workbook:
https://drive.google.com/file/d/1h8tn...
00:00 Introduction
00:24 Problem description
01:36 Background to SCAN/REDUCE
06:18 Start of Solution
10:21 Including the table name in the dynamic stack
13:53 Making the solution better
15:42 Concluding thoughts