Forum Discussion

serhito's avatar
serhito
Regular Visitor
5 years ago
Solved

Multiple web queries

i have a list of stocks in excel. I need to do a web query for each one of them with their own url. In the next column, I have built the required url (which includes the stock symbol) How can I aut...
Need Help
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    Hello serhito 

     

    you have to load this table into power query, add a new column where you access the data probably with Web.Contents using one or both columns in your table (I can't know what you are really looking for). Depending on what you will get from this data source you can pivot your first column. But I think you will get a table from your data source that however you have to transform, before you are able to get a single value.

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy