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:
[ Ссылка ]

Contact me:
oz1.depot@gmail.com

Website: [ Ссылка ]

My book: Guerrilla Data Analysis 2nd Edition
[ Ссылка ]

My old blog: [ Ссылка ]

свернуть