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 best-read stories of last year and a lookahead to the coming trends. Plus: our annual corporate jargon Eye-roll awards.