remove missing values

[mahendrapal1792]

I have a table on my Power query editor that has two columns in the first column all values are available but in the second column there is one cell that has a blank value i dost understand how to remove that entire row  i have uploaded image before filter and after filter  and i want to remove this  after filter row entirely what to do  

[ChiragGarg2512 · Accepted solution]

@mahendrapal1792 The most basic solution is to delete those columns by going to manage and then delete. 

Or a filter can be applied in the advanced query editor for taking only those values that have non empty column 2.