DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,652
- Office Version
- 365
- Platform
- Windows
Can someone please help me?
I am trying to use PowerQuery to create a table in Excel of all the golf majors. I wish to extract their dates from the Wikipedia articles for each tournament.
For example, from this web address [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://en.wikipedia.org/wiki/1895_U.S._Open_(golf) I want the contents of the Dates field in the box on the upper right side, October 4 1895 in this case. Then 1896, then 1897 all the way to 2019. I reckon it's just some kind of parameter process but I can't seem to get it right.[/FONT]
I am trying to use PowerQuery to create a table in Excel of all the golf majors. I wish to extract their dates from the Wikipedia articles for each tournament.
For example, from this web address [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://en.wikipedia.org/wiki/1895_U.S._Open_(golf) I want the contents of the Dates field in the box on the upper right side, October 4 1895 in this case. Then 1896, then 1897 all the way to 2019. I reckon it's just some kind of parameter process but I can't seem to get it right.[/FONT]