Forum Discussion
Solved
Filter rows results in one row with errors in every column
Hi, I am transforming data from an excel file. The data isnt in the best format so one of the first things i do is filter out any rows with null or blank values. I know the error probably orig...
The #REF! value isn't a Power Query output, it's an Excel ouput, so you should be able to select one of the very first steps in your query (before any column transformations have been done) and find the row with this value in it, right-click on the cell value and go to Text Filters > Does Not Equal.
Pete
The #REF! value isn't a Power Query output, it's an Excel ouput, so you should be able to select one of the very first steps in your query (before any column transformations have been done) and find the row with this value in it, right-click on the cell value and go to Text Filters > Does Not Equal.
Pete
That worked thanks!