Power Query Specialist to Edit Code

ONLY REPLY IF YOU HAVE EXPERTISE WITH POWER QUERY and M programming language in Excel and can do this job within 2-3 hours. PLEASE ALSO LOOK AT ATTACHED FILE AND PROJECT DESCRIPTION TO MAKE SURE YOU UNDERSTAND TASK.

I have created the attached basic spreadsheet. In summary, if I enter a url in column A from the website [url removed, login to view], refresh the table in D:G, it will scrape the data from the page. However, if you go to [url removed, login to view] it will briefly show "no markets available". This is sometimes scrapped and the data will be blank. And I can't figure out a way to fix this!! So that's what I need help with.

It could be as simple as IF first row is "no markets available" THEN refresh feed again UNTIL first row <> "no markets available". But I'm really new to power query so don't really know how to do that! Have found this on google [url removed, login to view] but can't really find much more help.

I tried invokeafter but couldn't get that to work so have put the time delay back to 0 secs. You will see an example of an individual feed on Sheet2 as well.

So all I need is that small bit of code written. Ideally within 2-3 hours of this posting

Thanks

Excel

ID Projek: #15014058

Tentang projek