Excel Power Query - Get Data from Web (+ Special Trick on Removing Space)
When you want to get Data from the Web, e.g. Wikipedia, do you Copy the data and Paste into Excel? I did that in the past but not anymore.
Copying the data is straightforward but pasting will not get the result you want. It's better to use Power Query! It takes a little bit of effort to learn but it's worth it - saves more time in the long run.
Stay tune because I have also included a SPECIAL TRICK on how to remove NON-BREAKING SPACE!
Watch the video to find out more. Enjoy!
Comment below if you are using this shortcut or trick!