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.
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.