PQ: Remove/Delete rows if specfic row of all columns are blank.

[countryfan_nt]

Hello friends, Hope all is safe & well!
Please help me with Power Query. I want to delete the entire rows: 7, 11, 13, 14 and 15; based on the conditions that all cells are empty in all existing columns.

Thank you very much in advance!

Please

 

[shaowu459]

= Table.SelectRows(Source,each not ([ProjectAlias] = null))

This will remove entire rows of the table if [ProjectAlias] is null.

 

[sandy666]

as I said before (post#20) you can

or just filter ProjectAlias column by null

anyway you need to know what and where features are in the PQ editor and how to use them
I suggest to read

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

docs.microsoft.com

have a nice day

 

[countryfan_nt]

you guys are truly awesome!!!

 

[sandy666]

You are welcome and thanks for the feedback