With Power Query in Excel, you can add a conditional column to your query. You can define IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column will automatically display the values that you specified. Learn more at the Excel Help Center: https://support.office.com/excel