Power Query with Unique URLs

[Deleted]

Hi,

So I'm recently doing a project where I have to get data for each user from a website url, but the website url varies on the username. For example the begining of the URL is www.site.com/username=. I have all the usernames in cells A1:A201, so for the first username would have a set of data at www.site.com/username=User1. Is there anyway to make a Power Query that will return the data from each individual URL (all 200) and have it displayed in the adjacent row (B1:B201)?

[#2]

Hi Salvatore

You'd need to use a custom function

I've attached a demo file here for you to look at

[#3]

I have the same problem. Have a row with links and want to use it as URLs for Power Query. I try to download this file, but I see only two link. screenshot: http://pix.my/C8e96l

I have MS Excel 2013

[#4]

Logicaly, i want something like this http://pix.my/tbFRuL

[#5]

Hi
The file I attached contains a Power Query function that references that Table.

You will need to click "show queries" or "Query Pane" in the Power Query addin tab in order to see the function

[#6]

There's a really good article here by Excel MVP John MacDougall that could be exactly what you need

https://www.howtoexcel.org/power-query/how-to-extract-data-from-multiple-webpages/