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

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

This project is a port of the excel-formula library to ES6. It contains a set of functions that can be used to pretty print Excel formulas and convert them into JavaScript, C# or Python code.