Unable to remove last row of errors

[Joiner]

Hi, the problem I have is my last row has "Error" in each cell. My applied steps are:

1. Merge Queries
2. Expanded TableB
3. Removed Duplicates
4. Filtered Rows

After #3, I'm unable to load data as a PivotTable or a Table. I've tried to remove error and remove last row but that last row of errors is still there. The reason why I need #3 is because the rows duplicate themselves and I need a column in TableB for lookup. 

[Anonymous · Accepted solution]

Hi @Joiner ,

For errors in tables, you can use "Remove Errors" option.

And you also mentioned that you want to remove the last row, you can use "Remove Bottom Rows" option.

Enter 1 and click OK.

According to your description, you may swapp the position of the step in Applied Steps in Power Query, it migh cause an error. This may be because you reversed the order of the steps, causing subsequent steps to not execute correctly. If you change the order of steps, it may affect the data that subsequent steps depend on, resulting in errors.

Applied steps - Power Query | Microsoft Learn

If you are still confused, please provide some more details about the error, such as the error message or screenshots. Take care to protect your data privacy!

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[ChiragGarg2512]

Usually remove duplicates doesn't give any errors.

Please share the dataset.