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, ...
Upgrade from standard Excel workbooks to specialized formats that shrink, shield, and streamline your spreadsheets.