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, ...

The worksheet class represents an Excel worksheet. It handles operations such as writing data to cells or formatting worksheet layout. A worksheet object isn't instantiated directly. Instead a new ...