I recently asked in the VBA/Macros section about a code to download the second table of stats from this webpage: https://www.baseball-reference.com/l...pitching.shtml
A kind person wrote a fine solution, but in the thread another another person told me just to use Power Query. He showed me a picture of his results in order to demonstrate
Screenshot 2024-04-10 082841.png
I tried to achieve the same result using my Power Query. However my results vastly differed!
Screenshot (4).png
For some odd reason which we could not figure out in the thread, my Power Query simply will not locate the second table from the URL after I post it in the editor. However, as indicated above, the instructor's Power Query was able to pull it up.
I am hoping this is not a problem with my version of Excel, or perhaps it's some setting in options I need to tweak. I'm also hoping there is someone here who really understand Power Query and can help me resolve this issue. Thanks in advance.
Bookmarks