How to Stack Multiple Columns into a Single Column in

Check out our newly launched M Language course ↗️ - goodly.co.in/l...
In this video, you will learn how to stack multiple columns in Excel, combining them into a single column with all the values stacked one below the other. You will learn how to convert the columns into lists, combine them, and then transform the combined list back into a table.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨‍🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@GoodlyChandeep]

M Language course ↗ - goodly.co.in/learn-m-powerquery/

[@eslamfahmy87]

Actually, the shortage videos are more efficient. Please continue by using the most power qurey usage function by displaying the function name and explaining how to work.

[@randomguy-jo1vq]

You are insanely good at the data cleaning and transformation

[@Luciano_mp]

Awesome, thank you!

[@PowerMacro]

You are awesome always Chandeep Sir 🎉🎉🎉🎉🎉

[@shahidkarim2260]

Wow good explanation bro

[@OmbaWemaluwa-n2k]

moving too fast. how did you get to the table.columns(source). which cell are you working on?

[@zdzislawkes]

I wonder what benefits/disadvantages compared to Your solution can be obtained by using function unpivot? Thank You very much for your videos.

[@randomguy-jo1vq]

Unpivot gets slower with large Datasets whereas this approach is faster.
Unpivoting doesn't consider null in Datasets whereas this approach captures null values as well.

[@zdzislawkes]

Thank you for your comment. Can you tell me whether, given the same number of elements, which method will be faster?

[@paravej]

Wow as usual bro....

[@rajkumardevkar3345]

Unpivot will also do?

[@alexrosen8762]

Very useful 🙏👌👍

[@silverfunnel6819]

Applause👍

[@alan_dzhanibekov]

Open that excel list, fix it, reload.
Any PQ actions make report slow

[@Hamish_A]

Manual action is fine IF, and only if, you're doing this just once.

[@jeetpranav2304]

Legend 🎉