Picture this: yet another Excel report lands in my inbox, and, once again, it's a nightmare of leading spaces, inconsistent spelling, and useless rows. Previously, I would spend hours fixing it ...

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