I would like to download data from a website to Excel in order to create my own statistics. I tried power query but couldn’t get everything I wanted.
For example, here is a specific URL:
https://www.betexplorer.com/football/algeria/ligue-2/
On this page, the next matches section is downloaded, but not the standings. And only a part of the results, because under the results there is an inscription “show all results” that you have to click on to reveal all the results.
Can someone help me with how I can download the data on the page with an Excel macro?
Someday I would have to download more similar data, which is very slow manually, so I would like to automate it.
(I use excel 2013.)
Thank you in advance for your help!

I tried power query but couldn’t get everything I wanted.