Excel Dynamic Array: Column of Records into Proper Data Set (Excel Magic Trick 1531)

Download Excel File: https://ift.tt/2zEgCVN
In this video see how to use Excel 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: https://ift.tt/1kSFWvs
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)

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.