Check out our newly launched M Language course ↗️ - [ Ссылка ]

In this video, we will learn to remove junk rows from the top and combine data from multiple Excel files. We will explore three Excel files, each containing a few unwanted rows at the top. Our goal is to remove this inconsistent number of junk rows and merge the data from all the files automatically.

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
[ Ссылка ]

✔️ Power Query Course-
[ Ссылка ]

✔️ Master Excel Step by Step-
[ Ссылка ]

✔️ Business Intelligence Dashboards-
[ Ссылка ]


===== LINKS 🔗 =====
Blog 📰 - [ Ссылка ]
Corporate Training 👨‍🏫 - [ Ссылка ]
Need my help on a Project 💻- [ Ссылка ]
Download File ⬇️ - [ Ссылка ]


===== CONTACT 🌐 =====
Twitter - [ Ссылка ]
LinkedIn - [ Ссылка ]
Email - goodly.wordpress@gmail.com


===== 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!

свернуть