Here’s a quick video correcting 2 things from the previous video: Import Data from Web Page and Clear Line-Breaks
Thanks: Wyn Hopkins, Micheal Reynolds and Chris Pope for pointing these out:
1. There was a single carat delimiter that I missed
2. There’s a way in Power Query (Get and Transform) to separate columns by line-feeds and carriage returns.
Have a look! And thanks for being in the battle against Crap Data.
Also, I mention the Amsterdam MVP Excel Summit. It’s 2 days of Excel MVPS teaching the public the greatest about Excel.
It’s 18 and 19 April. Here’s a link for more details:
My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2