Download Excel File: https://excelisfun.net/files/EMT1646.xlsx
Learn how to append 3 columns using a huge Dynamic Array Formula. Bill Szysz gives us this trick. See the Functions: CHOOSE, SEQUENCE, ROWS, COLUMNS, MOD, INDEX, FILTER, NOT, ISNA. Learn how to mash columns together side by side with Excel Worksheet Formula. Learn how to mash columns together One On Top Of The Other with Excel Worksheet Formula.
1. (00:01) Introduction.
2. (00:51) Mash columns together side by side with CHOOSE Function.
3. (02:20) Concept for creating Row Numbers and Column Numbers to spill a table of values into a single column.
4. (03:00) Create Row Numbers with SEQUENCE and MOD Functions.
5. (04:51) Create Column Numbers with SEQUENCE and 1/ROWS.
6. (06:07) Mash columns together One On Top Of The Other with INDEX, FILTER, NOT and ISNA functions.
7. (07:12) Summary and End Video Links.