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.

Using the example in our spreadsheet or a similar spreadsheet, highlight all the revenue numbers in the sheet and then in the ...