Import Data From a Website

Hello Again Everyone! I hope you are all doing well since the last time I posted

I play Massachusetts state keno, and in the past I was able to copy the numbers off lottery's website, and paste them all into rows in Excel. Now the lottery has changed their website, so when I copy the numbers, they paste horizontally into columns instead of vertically into rows. I realize I can transpose each one individually, but that would take way too much effort, and time.

I believe what I am looking to do I guess is run a power query? Where the data is imported automatically into Excel from the lottery's website. I am looking to import all past results as well as all future results.

Attached is an example of the layout which includes the first 20 keno draws from today (6/5/23)

Also attached below are the links to the Massachusetts State Lottery keno past draws, as well as a link to Massachusetts State Lottery Data Base for today (I only know how to find the data bases by days, and not all the draws on one page)

https://www.masslottery.com/tools/pa...sort_by=oldest

https://www.masslottery.com/api/v1/k...ate=2023-06-05

I appreciate your help with this issue. Thank you all