I am familiar with how this tool can extract data from tables on websites like Wikipedia, but I've run into a few issues. HereHere is what I need to happen, if possible with Excel, or any other software:
That was accomplished with a simple Copy & Paste to Match Destination Format, but that won't keep it dynamic. WhenWhen I use the query editor, I immediately notice that it won't work the way I'd like it to unless the tables are actual HTML tables. ItIt is possible to drill down until I find text, but I have no viable method to understand where I'm going.
There is no option available to select regions containing data that I'd like to be in a table, unless it fits the aforementioned format. AlsoAlso, some pages that would normally allow it, have an IE compatibility issue that I'm not sure how to circumvent. IfIf I could use Chrome or Edge instead that would be helpful.