Forum Discussion
Solved
Excel PowerQuery, entire row has Error
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
ChrisC365 - Right + Click > Remove Errors does not work?
2 Replies
ChrisC365 - Right + Click > Remove Errors does not work?
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
