Excel Dynamic Arrays: Unstack a Column of Records

/in /by

The classic problem: unstack a column of records in Excel.
This video shows a cool way to get this stuff un-stacked. You’ll see the FILTER Dynamic Array function, the SEQUENCE Dynamic Array Function, and even the SORTBY.

You’ll see cool uses of regular Excel functions that act like arrays. This is real fire, baby!

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2