Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1713.xlsx
Learn how append tables that contain a small amount of data using the following functions: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. Learn a great trick in the row_num argument of INDEX function to unwind a column of records into a table.
Topics:
1. (00:00) Introduction.
2. (00:30) First look at formula.
3. (00:48) Drawback of formula.
4. (01:11) What is XML language?
5. (02:59) TEXTJOIN formula element.
6. (04:26) FILTERXML formula element.
7. (05:21) INDEX and SEQUENCE formula element.
8. (07:27) Final formula on Grade Data.
9. (08:22) Look at what happens if there are more than 32,766 characters.
10. (08:38) What to do if there are empty cells in tables.
11. (09:01) Summary, Closing and Video Links.

Excel Wizard Video:
https://www.youtube.com/watch?v=0mxhftN4Fk4
Abiola David Video:
https://youtu.be/50x6SCH2OFI

ExcelIsFunTue, August 10, 2021 4:09am