Textsplit function workaround(Part 2) - REDUCE Function

Textsplit function is unable to spill a 2-D array i.e spill into multiple row and multiple column. The video shows a workaround to TEXTSPLIT and making it spill using the REDUCE function 00:00 Introduction 00:15 Understanding the challenge 02:30 SCAN Introduction 04:45 REDUCE Function Introduction 05:47 Solution with REDUCE function 07:40 DROP and IFNA for finesse 09:10 Concluding Remarks Link to Excel workbook: https://docs.google.com/spreadsheets/d/1sG1WRKqL8a_3z1cZA8I2sUZZOBTJX4M5/edit?usp=share_link&ouid=115481529442131367093&rtpof=true&sd=true