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 ...
ChrisC365 - Right + Click > Remove Errors does not work?
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