Remove unwanted rows

[Anonymous]

Hi,

I have created a sample data in which column Id has values like underscore (_), (null), (blank) etc. (refer rows 5 to 8 in attached file).

I understand there is an option "Remove Empty" which removes blank rows. In this case, row no. 5 will be removed. To remove the other unwanted rows, I will have to replace each of those values with a blank row and then use above option.

But when I select the column Id and navigate to Remove Rows -> Remove Blank Rows, none of the rows are removed.

How does the Remove Blank Rows option work?

Please explain using this same example and sample data. 

Thanks,

Vishy

[Baskar · Accepted solution]

@Anonymous

Add those two lines in your Power Query. 

Text1 = Table.SelectRows( Text, each [ID] = Text.Select([ID],{"a".."z","A".."Z","0".."9"} ) ),
#"Filtered Rows" = Table.SelectRows(Text1, each [ID] <> "")

[Greg_Deckler · Accepted solution]

You should be able to click on the drop down arrow of a colum and remove values that you do not want (uncheck) and those rows should get filtered out.

[Baskar · Accepted solution]

@Anonymous

Add those two lines in your Power Query. 

Text1 = Table.SelectRows( Text, each [ID] = Text.Select([ID],{"a".."z","A".."Z","0".."9"} ) ),
#"Filtered Rows" = Table.SelectRows(Text1, each [ID] <> "")