Excel Dynamic Arrays: Unstack a Column of Records
2,261 views · Published 4 December 2018 · 4:56 · Indexed 25 September 2026
Channel: Excel On Fire (Oz du Soleil) · 2018 · Education
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: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My old blog: http://datascopic.net/blog-2-2
More from this channel
-
5:03
Basic Excel Table Demo
-
10:28
Generating Random Data to Set Up a Pivot Table Tutorial
-
8:23
Excel Data Validation: Why It's Important
-
3:41
Excel demo: retrieving current and historical stock data from the web.
-
5:45
Sriracha Taste Test 2: Sky Valley, Saigon Sisters & Lee Kum Kee
-
5:09
The Power of Excel & Data: Oz at IgniteChicago
-
8:38
Excel Helps Determine the Dog's Fate
-
18:20
Pressman by Primus (Using Excel to study song structure)