Quick Excel Trick to Unstack Data from one Column to Multiple Columns

Thxs for sharing but when the rows per block are different? for example 3 rows after 4 row and after again 2 and so on for thousands rows? how to unstack to columns right?

great trick! I have a concern though, what if my data in one column does not have a fixed pattern in terms of the number of columns but let's say every time the data point is a date, it has to go to the next row? I've been trying to find a solution, I hope someone could help me please :(

The best way to regroup a set of 1-dimensional sequential data to 2-dimensional tabular form.

Thank you, Leyla! What if there are different umber of rows after each heading (not just three)?

Woaw, just amazing

There is no need to put your initials. You can put the =A? up to A6 and then Excel will see the pattern.

I kinda like the indirect formula for something like this. There are three variables so it would be something like =indirect("A"&3×c4+1) where c4 would be the iteration number, 1 would be the variables after the original and 3 would be the number of new columns being created.

Great video. Is there also a convenient way to unstack a long row of data into a table, if not first transposing that row into a column?

Can we add attachments automatically while sending such mails, for example I am daily updating the debtors list after receiving payment from the customer and every time I have to generate new mail with upadated sheet. Thank you

Pls make a video in excel, A set of data copying multiple times very easily

Amazing

Tks for sharing this trick. ❤❤❤

Awesome & simple

Thank you so so much!!

Really amazing WOW ❤❤❤

Genius! Thank you!

Brilliant and amazing!!!

You are awesome!

Thank you I have been looking for solving this problem for a long time. Your videos are amazing

Awesome! this saved me a lot of time.

Your channel is a life saver!

Nice trick

I added emails and I put exact format you used. However when I extended the format for the other 2 emails, it doesnt change and use the new email address. It still sends it to the original email used in c5 cell. where do I make the mistake?

Genius! thank you !

this is awesome

Girl, you rock. Thanks for all you do.

And now you can do this with WRAPCOLS -function. 😀

So Easy to follow all your course

A BRILLIANT resolution to my exact problem. I am now a new subscriber and I will be back soon to probe your brain some more. Thanks so much.!!

This is brilliant - thanks!

Absolutely brilliant! This is exactly what I was looking for.

Really Appreciate From (Pakistan)

Wooow.

unbelievable shortcut you created Ms Leila..... Hats off !!!

Brilliant!!!!!!

Try this - =INDEX($A:$A,ROW(A1)*5-5+COLUMN(A1)) where 5 is the length of the repetition. Thanks!

The LG idea replecment , just saved me a ton of time ... thank you veeery much :)

Smart and easy method to follow. Thank you very much!

Every time! If I'm stuck, you come through. You're awesome. Thank you!!

Answering the questions i have when others are answering the opposite from the same search query. Thank you.

I literally started laughing from excitement when I saw the email come through!! Thank you so so much for this video it is going to save me so much time and will definitely reduced my typing errors! Fantastic tip thank you so so so much!!!

چقدر باحال ...

A great and very smart way of doing it. Thanks, you are a treasure.

Thanks!

Genius! Thank you!

really smart function!!! thanks for sharing:) I enrolled your lesson already!

This is the best video ever, thank you so much