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: [ Ссылка ]
Ещё видео!