title: How to ignore Excel Query Errors
body: <p>I am using Excel's Power Query for data analysis. In the file that contains the original data, there are about 15 columns. The query is only pulling data based on one of the columns. For example, the column contains either 'A' or 'B'. I want all data of that row if that certain column is a 'B'.</p>
  
  <p><a href="https://i.stack.imgur.com/RLgd6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RLgd6.png" alt="Example of my Excel data"></a></p>
  
  <p>The problem is in Column A, all of the names are text except for row 5. It's a decimal. Excel Power Query will throw an error and say it doesn't match the other rows. It will still query the data and pull it into another file, but with throwing the errors.</p>
  
  <p>Some of my data will not match like in this example. So is there a way to ignore these errors? I still want the data from the original file; I just want to tell Excel that it's okay if the row data doesn't match other rows. I've formatted the entire column to one type and that doesn't seem to solve the problem.</p>