title: Iterating over each cell in a column in Power Query
body: <p>I created a table called Table3 with two columns named URL which is empty and Value which contains a list of websites. The following query retrieves data from the websites stored in Table 3.</p>
  
  <pre><code>let
      Parameter = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
      URL= Parameter{1}[Value],
      Source = Web.Page(Web.Contents(URL)),
      Data0 = Source{0}[Data],
      #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Volume", type number}, {"Market Cap", type number}}),
      #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Market Cap", "Open", "High", "Low"}),
      #"Sorted Rows" = Table.Sort(#"Removed Columns",{{"Date", Order.Ascending}})
  in
      #"Sorted Rows" 
  </code></pre>
  
  <p>The second line runs the query for the first website in the Value column. </p>
  
  <p>Is it possible to introduce a loop that would run the query for all the websites? </p>
  
  <p>If not is it possible to run the query for all the websites in sequence by manually pasting the above code and changing the number in the brackets for each website? </p>
  
  <p>If it is possible I assume it would load the contents in the same sheet, is there any way to load the content in different sheets for each iteration? </p>
  
  <p>Thanks for reading my question. </p>