Any null values will show as blank cells in the final Excel table. If you'd prefer to fix this within the Power Query Editor, ...

Queries are the database equivalent of filters in a spreadsheet. Just as a filter can limit and reorganize the information displayed in a spreadsheet, so a query limits and reorganizes the information ...

Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how. Simply use the DISTINCT clause and between the SELECT clause and the fields.