Excel PowerQuery, entire row has Error

[ChrisC365]

Hi

Hello

See picture below, how do I remove a complete row that has or shows 'Error'.  I have tried to remove last row, replace error with value 0, transform a column back to text, but I can not get it to shift.  The source file has a formula that is throwing up a '#n/a' error.

Error

Many thanks

Chris

[#2 · Accepted solution]

@ChrisC365 - Right + Click > Remove Errors does not work?

[#3]

@ChrisMendoza 

I tried a new approach this time.  I found if you select 'Remove Errors' first this seems to do the trick.  Before I was first change the type of formatting columns; change to text, decimal etc, and now it seems to have worked.  So thanks for your response.

Chris