How to Stack Columns of Data in Excel: Formula Method, Power Query Method

Lately, there have been a number of requests for stacking data that's in multiple columns.

This video shows 2 methods for stacking 3 columns of data:
- The INDIRECT formula can be used once we know the pattern of how the data needs to be rearranged.
- In Get & Transform (Power Query) it's simple: add an index column, then "unpivot other columns." BOOM! DONE!

Download the Excel file here:

My book: Guerrilla Data Analysis 2nd Edition

[glempy]

After HOURS of groping, I came across your AMAZING video - To the point - Perfect! THANK

[ladyzana]

OMG!! I am working 303K cells of data points to plot to a 3-D sphere that had covered nearly 400 columns and thousands of rows. You just made my life so much easier. I am so glad I found your video. Thank you for taking the time to do this.

[carrillo]

You made it seem so easy, while others make you write some crazy formulas. Thank you.

[ahmadomposurono]

You Sir, are a gift from God to normal peasant cultivating on excel field like me. Thank you so much. May one day you receive a Nobel prize in Excelogy.

[REInvestorCEO]

Second time I've ran across your videos when I had a question on how to do something. Greatly appreciate you posting these videos!

[gailsilvestre]

Jesus Christ! You helped me so much! I love your style. Please keep up your awesome work.

[KrisLI]

Brother you saved my life. Thank you very very much.

[jameshowsam]

Great video, the Get and Transform method has helped me do something with a monster spreadsheet I've been trying to figure out how to automate for weeks. Cheers!

[sawyersmill]

Wow! To the point and understandable as well. You nailed it. Thanks!

[GainaIytics]

Sir, you're a lifesaver! Thank you SO much!

[einekleineente]

Great stuff! You saved my a55!! Thank you!

[razorback]

BEST METHOD THANK YOU! GET AND TRANSFORM FTW

[dannycr]

Excellent add, just what I needed, thanks a lot sr.

[sheilastegbauerschatzke]

thank you so much for this video, you just saved me a bunch of time. I appreciate you.

[mohamedchakroun]

Learn New trick = more expertise thank you oz

[eshrubsole]

great information here!! can either method work if my data has an uneven number of rows completed?
e.g. 1 column has 50 entries 2nd column has 35?

[miguuel]

Thanks mate, this a great video, you saved me lot of time :-)

[bumpyb]

MY HERO!!! thank you. many hours of wasted time - no more!!

[suswalk]

I did the 2nd method, but I lost all my formatting & hyperlinks. Is there a way to do this and retain them?

[renejavier]

Thanks, I appreciate your help. Its a real time saver tool