title: Power Query from files in Folder specify column selection
body: <p>I think I need to specify the columns to be imported from files in a folder, as the auto-generated files that are scheduled to save to the location have a title in cell A1 with header/data table further Starting at row 6.
  As there is only one column with data in row 1, Power Query only pulls in column A to work with.  But I need it to pull in Columns A to E so that I can perform the Transform to get the table data I need.</p>
  <p>Can I specify the columns for Power Query to recognize so I can get all my data?</p>
  <p>Example data:<a href="https://i.stack.imgur.com/lCxNu.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lCxNu.jpg" alt="enter image description here" /></a></p>