Forum Discussion
removing rows with blank value on multiple columns
selpaqm
In Power Query, Select All three Columns (salesman,country ,customer).
On the Add Column Tab, Click Merge Column,
In your new Column, Filter out blank,
You get the desired results
You can delete the merged column________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
When the dataset is reloaded with new data, would the filter then include new values that was not in the table before (will it still only exclude blank values)? Does any one know?
After clicking the conditions on the step, it seams indeed that it does only exclude the blanks (meaning it will include new values that will appear when reloading data later on). Great 🙂 :