How to remove blank rows in Power Query Excel

How to Remove Blank Rows in Power Query (Excel Tutorial) In this short Excel Power Query tutorial, you’ll learn step-by-step how to remove blank rows from your table so your data is clean and ready for reporting or analysis. In this video I show you: How to load data from Excel into Power Query How to remove completely blank rows using Remove Blank Rows The difference between fully empty rows and rows with only some missing values How to remove rows where a specific column (for example Product) is empty How these steps look in the M code editor This trick is perfect when you receive messy data with lots of empty lines and you want to clean it automatically instead of doing it manually in Excel.

How to add prefix in Power Query

How to add prefix in Power Query #powerquerytutorial #exceltips #powerquery Do you still add text manually to every cell in Excel? 😅 In this video I show you how to use Power Query to add a text prefix (for example "10") in front of all values in a column – in just a few clicks. We start from a simple table with columns ID, Product, Code and transform it so that every code becomes 10A01, 10B15, etc. This trick is perfect when you work with large datasets and want to clean or standardize your data quickly. 🔧 In this video you’ll see: How to load a table into Power Query How to use “Add Prefix” on a column How to build a simple Custom Column with "10" & [Code] How Power Query automatically creates M code for you 💡 Great for: Anyone who works with Excel reports People who want to automate repetitive text changes Beginners who are just starting with Power Query If you found this useful, don’t forget to like, comment, and subscribe for more Excel tips! 💚