FILTER function in excel to stack tables with VSTACK/REDUCE
How to use the Filter function with Reduce and 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://docs.google.com/spreadsheets/...
00:00 Introduction
00:29 Problem description
01:26 Background to SCAN/REDUCE
05:08 Start of Solution
08:35 Including the table name in the dynamic stack
11:05 Concluding thoughts