Dynamic Array: Unstack Data with SEQUENCE ... just 2 steps
Here we are again!
I was playing around more with the Dynamic Array functions, especially after Leila Gharani posted her video that made unstacking data pretty easy with a substitution trick and finding a pattern in the dataset. Here is her video:
• Quick Excel Trick to Unstack Data from one...
Well, I found a 2-step process that REALLY simplifies unstacking a column of data. SEQUENCE, COUNTA and INDEX get us there, taking advantage of spilled arrays and Excel's new calculation engine. Alas, not everyone has the Dynamic Arrays yet. If you don't have them, and you need to unstack some data, use Leila's method. 👍
For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/ins...
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2
In questa pagina del sito puoi guardare il video online Dynamic Array: Unstack Data with SEQUENCE ... just 2 steps della durata di 03 minuti 40 seconda in buona qualità , che l'utente ha caricato Excel On Fire (Oz du Soleil) 16 gennaio 2019, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 52,653 volte e gli è piaciuto 1.3 mille spettatori. Buona visione!
