Google Sheets: Dynamic Arrays - SORTN, SPLIT, QUERY, SPARKLINE++

The dynamic array concept is one formula can return a table (with multiple rows & columns), with this comes a slew of extra functionality, with new functions and changed behaviour on existing formulas through ARRAYFORMULA. You can also stack different tables on top of another through using {}. Dynamic array functions include TRANSPOSE switches rows & columns, SPLIT separates text in multiple columns based on a character, UNIQUE returns a unique list based on a source. SORT and FILTER apply those common actions in an output range, IMPORTRANGE grabs a table from elsewhere, GOOGLEFINANCE fetches live stock data, SPARKLINE creates in cell charts, ARRAY_CONSTRAIN allows you to limit the max area, SORTN, and finally the incredibly sophisticated QUERY function. Explore the QUERY function further here: https://youtu.be/4pdwoLGhzJ4 Excel introduced dynamic Arrays in 2020, but Google Sheets has had them for a lot longer, and they are much more sophisticated. 00:00 - Introduction 00:40 - UNIQUE 01:28 - TRANSPOSE (switch rows/cols) 01:52 - SPLIT (text to columns) 02:34 - ARRAYFORMULA 03:28 - Stacking tables 04:15 - IMPORTRANGE 04:53 - GOOGLEFINANCE 05:43 - SPARKLINE 06:19 - SORT 07:16 - ARRAY_CONSTRAIN 07:38 - SORTN 09:57 - FILTER 11:18 - QUERY