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:

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:

My book: Guerrilla Data Analysis 2nd Edition

[SuckMyGreasyPrick]

*To put this into ONE formula, you can combine the two formulas into this....*

=INDEX(Table1[All kinds of folks], SEQUENCE(COUNTA(Table1[All kinds of folks])/3, 3))

EVVYTHANG - UNSTACKED - 1 STEP - 1 FORMULA

[JorgePerez-rzir]

Speechless as to how AMAZING this is!! This like a one-touch tutorial. Dude spits it once. Amd its locked in my head!

[melatone]

In my career as an analyst I have probably watched a million Excel tutorials on different things and this is a refreshing ray of sunshine in an otherwise dreary green and white world. Thank you for the great tutorials!

[LeilaGharani]

Love this Oz! Unstacking is becoming more & more fun :)

[MrBlitzNZ]

LOVE IT!, as a excel enthusiast this was entertaining, humorous and I learnt something. If only I could up vote more than once.
Instant subscribe for more sexy excel action. 😀

[JayFolipurba]

give this man a medal. And wow, that charisma!

[joshgoldbeck]

As a bit of an Excel geek, I must admit to enjoying your videos about efficiency in Excel, but you really stole my heart with the chocolate milk at the end. Wow, love it!

[OlaJustin]

T-series better watch out, this man has made Excel entertaining. This is earth shattering for all kinds of folks! Great tip!

[TheSofox]

I have never watched an Spreadsheet tutorial video the whole way through before, and I'm so happy that this was my first one.

[barbesque]

My man! These are the most creative tutorial videos ive seen on youtube. Amazing job, love the whole style. Well earned subscribe

Dude thanks to your channel I am the magic mambo of excel of my office.

[load]

I gotta say, learning from a master Funkateer is the righteous way to learn arrays.

[Paheej]

Hey man, just want to say that I love your presentation style and enthusiasm for data with Excel. Keep fighting the good fight man!

[von...]

I've been out the excel game for a while and tbh your videos are so helpful and I love the presentation of it all! subbed

[sasavienne]

You are amazing. 🌟 Merci Oz du Soleil. C'est magnifique..

[DantheAudioman]

This is the best thing I've seen in a long time!

[UpExcel]

Great stuff, made even better by your enthusiasm and fire balls Oz 💥👍

[Thunterise]

I didn't know there was a video anywhere online that could get me hyped on Excel, but this one managed it somehow.

[mathteacher]

Thank you and subscribed!

EDIT - This may not work on all versions of Excel. From the help file when I looked up "Sequence":

"Note: September 24, 2018: The SEQUENCE function is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll continue to optimize these features over the next several months. When they're ready, we'll release them to all Office Insiders, and Office 365 subscribers."

[ernests]

Men, you are awesone! This vevo made my day! :D