How to automate or repeat the steps for the same table layout in power query|Power Query|Excel Forum|My Online Training Hub

Hi,

I am importing data from a website that has the exact table(s) layout even if URL changed but the same layout still exist.

For example these URLs include different information but the layout is the same:

https://www.gsmarena.com/apple.....-11089.php

https://www.gsmarena.com/apple.....-11102.php

https://www.gsmarena.com/apple.....-11103.php

I am repeating a lot of steps and wondering if I can automate or redo it automatically.

For example when I load data I get this page:

So, I am always selecting the same exact tables whatever was the URL because all URLs has the same layout.

So after I select the tables I am doing some steps on each table, like add some columns, delete some rows ...etc.

so how to repeat it and do it automatically?

Thanks