filmov
tv
Stack Multiple Columns into One in Excel with this TRICK!
Показать описание
Learn how to stack multiple columns into one in Excel using Power Query! 📊 I’ll show you how to:
1. Turn columns into lists with Table.ToColumns.
2. Combine them with List.Combine.
3. Convert it back into a single table.
It’s a quick and easy way to clean and reshape your data.
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
✔️ Mastering DAX in Power BI -
✔️ Power Query Course-
✔️ Master Excel Step-by-Step-
✔️ Business Intelligence Dashboards-
===== LINKS 🔗 =====
===== CONTACT 🌐 =====
===== 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'll find a ton of interesting videos that I have created :) Cheers!
1. Turn columns into lists with Table.ToColumns.
2. Combine them with List.Combine.
3. Convert it back into a single table.
It’s a quick and easy way to clean and reshape your data.
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
✔️ Mastering DAX in Power BI -
✔️ Power Query Course-
✔️ Master Excel Step-by-Step-
✔️ Business Intelligence Dashboards-
===== LINKS 🔗 =====
===== CONTACT 🌐 =====
===== 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'll find a ton of interesting videos that I have created :) Cheers!