Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1530-1531.xlsx
In this video see how to use Dynamic Array Formulas to convert a column of records into a Proper Data Set. This is a great trick from Bill Szysz.
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)