Enhancement to "Remove Blank Rows" – Column-based Blank Row Removal

[shubham3]

Currently, in Power Query, the "Remove Blank Rows" option only removes rows where all columns are blank. However, in many real-world scenarios, users need to remove rows where a specific column contains blank or null values.
For example, if a dataset contains a key column (such as ID or Date), and that column has blank values, users may want to remove the entire row based on that column alone.
It would be very useful if Power Query provided an option similar to "Remove Duplicates", where users can select one or more columns and apply "Remove Blank Rows" based on those selected columns.
Suggested Enhancement:
Allow users to select specific columns
Add an option like "Remove Rows with Blank Values in Selected Columns"
This would improve data cleaning efficiency and reduce the need for custom filters or M code
Benefit: This feature would save time, simplify data transformation steps, and make Power Query more intuitive for users handling large datasets.

[TinyMountain]

Why is custom M code undesirable? I usually find it necessary for any data pulls from non-cleansed data sources. Anyone who is designing semantic models and creating tables, columns, and measures in DAX should have no problem picking up M's much simpler syntax.