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




About this tutorial:

Video duration: 5:4
This trick is the easiest (or laziest) method to unstack data from one column to multiple columns. You might come across a case where you need to move data (or transpose data) from one column to multiple columns. If you Google this, you’ll find different ways of doing this such as:
1. Using Excel array functions or the INDEX function
2. Power Query to unstack data
3. Excel macros for unstacking data
4. Excel add-ins that can unstack.

In this Excel tutorial, we’ll take a look at the easiest method of unstacking data. The good thing with this method is that it’s dynamic so if your source…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

28 thoughts on “Quick Excel Trick to Unstack Data from one Column to Multiple Columns

    Learning Excel

    (September 10, 2019 - 3:40 am)

    Very nice and helpful trick

    Learning Excel

    (September 10, 2019 - 3:40 am)

    Very njce

    Yousif Mohammed

    (September 10, 2019 - 3:40 am)

    Wow.. Very simple, smart, and non-obvious workaround

    Md-Toushik-Ahmed Niloy

    (September 10, 2019 - 3:40 am)

    Madam, how can we do unstack if there is not uniform data? I mean if there is 4 profit values under voltage and 5 profit vaules lnkly and 6 profit values under sleops. Please give your valuable answer.

    Royce Mekolle

    (September 10, 2019 - 3:40 am)

    Please I will like to know how u will approach this if the pattern was uniform. Like some had 3 rows under while other had 2 and others with 5!?

    Coding with Anand

    (September 10, 2019 - 3:40 am)

    Very nice mem

    Green Peas

    (September 10, 2019 - 3:40 am)

    Wow!! I'm just getting addicted to your tutorial. May Allah give you the better return and solve your problems like you do for us!

    Naftuli Singer

    (September 10, 2019 - 3:40 am)

    Wow! That's Great!!! I had to do this a lot… Never thought of such an idea!

    rajanghadi1982

    (September 10, 2019 - 3:40 am)

    I am speechless. I know almost same as you know. I also have good logic. But you are far ahead in terms of great ideas. Hats off.

    Hari Krishna

    (September 10, 2019 - 3:40 am)

    Toppu

    Karim Eldardiry

    (September 10, 2019 - 3:40 am)

    I'm so glad that I saw this video, it saved me hours of work. Many thanks Leila

    Esther craft

    (September 10, 2019 - 3:40 am)

    Awesomeee trick

    Saiful EduWorld

    (September 10, 2019 - 3:40 am)

    Sir,
    Place make video missing serial this cell. Not another sheet,row&columns .
    thanks

    Life Goes

    (September 10, 2019 - 3:40 am)

    It's hilarious how these videos use such staged data sets to show examples. Try using real data.

    Joselito Muller II - não sou o Emanuel

    (September 10, 2019 - 3:40 am)

    Wow, amazing tip! Very smart!

    Muntasib Tehseen

    (September 10, 2019 - 3:40 am)

    You're truly genius

    Abhishek joshi

    (September 10, 2019 - 3:40 am)

    Your tricks are helping me a lot…
    Thanks for this..

    Suri Abreu

    (September 10, 2019 - 3:40 am)

    You're amazing!

    Martunas Turnip

    (September 10, 2019 - 3:40 am)

    Nice

    Sameer Khan

    (September 10, 2019 - 3:40 am)

    LG you are the best..

    Tufail Wani

    (September 10, 2019 - 3:40 am)

    Awasome…..

    rigfix

    (September 10, 2019 - 3:40 am)

    This is why i subscribe to this channel 🙂
    Simply brilliant!
    Thanks

    Yoko Yama

    (September 10, 2019 - 3:40 am)

    Another way to do it is put the formulas in the first row then highlight those 3 cells along with the 2 rows below so that 9 cells are highlighted, then drag that area down your sheet. You'll end up with rows of data with 2 blank rows in between but you can copy/paste values and then sort to get rid of blanks.

    Waleeth Mohamed Ismail

    (September 10, 2019 - 3:40 am)

    Obviously… Very useful shortcut method. Thank you very much

    Robert Long

    (September 10, 2019 - 3:40 am)

    OMG you genius!

    Sudeep Raj

    (September 10, 2019 - 3:40 am)

    Super awesome…

    Silver Wedge

    (September 10, 2019 - 3:40 am)

    Keeping it simple. Thanks.

    Samuel Thamburaj

    (September 10, 2019 - 3:40 am)

    Awesome Trick…

Leave a Reply

Your email address will not be published. Required fields are marked *