After several failed attempts to get data directly from the web into Excel / Power BI, I tried several web scrapers, of which only one worked halfways well.
Finally, I got an Excel file that looks like this:
I am trying to wrap my head around this data, and I was wondering if it's even possible to clean that data up with help of M?
It's barely digestable for a human ...
Obviously, it would take me less time to just manually copy and paste the data into a text file, clean it up manually and then load it into Excel. But I was wondering how a data pro would handle such a scenario, given the data set wouldn't be just a couple dozen addresses but a huge volume, impossible to get cleaned up manually.
Please bear in mind that the example above is totally arbitrary, based on publically availeable data, for educational purposes only.