The Automate tab is a gateway to another way of building smarter Excel sheets. It can handle the boring stuff so you can ...
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, ...