How To Extract Data From A Table With Multiple Website Url

[silvanus3805]

Please help I'm a struggling to extract data from a Table [Table 1] with given URL from multiple website pages , however The formula I used only gave me a option to extract from one row at a time in the column using absolute reference, which is inconvenient, is there a way to reference the whole column so power query can Extract data from all the URL the table in one query?

My code:

let
Query1 = let

//Get Text or CSV files from a folder

Path = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

Source = Web.Contents(Text.Combine({Path[Column1]{1}},"Column2"))

in
Source

 

[JGordon11]

maybe

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl = Table.AddColumn(Source, "Tables",each Web.Page(Web.Contents(_[Column1])){0}[Data]),
    Result = List.Accumulate(List.Skip(tbl[Tables],1), tbl[Tables]{0}, (s,c)=> s & c)
in
    Result

 

[silvanus3805]

Thank You!!Works Like A Charm!!

 

[JGordon11]

Here's a better way

let
    lst = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][Column1],
    lst1 = List.Transform(lst, each Web.Page(Web.Contents(_)){0}[Data]),
    Result = Table.Combine(lst1)
in
    Result

 

[silvanus3805]

Here's a better way

let
    lst = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][Column1],
    lst1 = List.Transform(lst, each Web.Page(Web.Contents(_)){0}[Data]),
    Result = Table.Combine(lst1)
in
    Result

Sure Thank You!!

 

[silvanus3805]

Here's a better way

let
    lst = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][Column1],
    lst1 = List.Transform(lst, each Web.Page(Web.Contents(_)){0}[Data]),
    Result = Table.Combine(lst1)
in
    Result

Can you Please help me with another Thread? Im Trying to get VBA To Change Values ( True / False ) In [Column2 VBA] everytime Selection.change event happens in the [Column1] range , lets assume the color in column1 is = vbred , I need vba formula to change the values (True/False) in the 2nd column based on the color in column1