How to fix a dirty data in Excel? (using PowerQuery)

The issue: More than once, you have received a spreadsheet with hundreds of rows and many cells missing, fiing each cell values manually takes a very long time, right?

Let’s see how we can fix that by applying logic and especially NOT having to do it again each time we load the updated dataset.

Thanks to PowerQuery (free tool within Excel and Power BI) we can do that very quickly and with NO code.