title: Using query, Import Range and named range to either label the named range or ignore the header
body: <p><strong>Context</strong></p>
  <p>So I am trying to put together some data to run a machine learning model. I need all the data in one google sheet. But I am importing the data from a different spreadsheet saved elsewhere.</p>
  <p>This is my current formula
  <code>=QUERY(IMPORTRANGE(&quot;link&quot;, &quot;AvevaReturns&quot;)) Screen reader support enabled.</code></p>
  <p>It returns the spreadsheet but with the column label which is located in row 3 (two rows above it are blank).</p>
  <p>I have tried <a href="https://webapps.stackexchange.com/questions/116781/google-sheets-queryimportrange-with-named-range">this</a>, <a href="https://stackoverflow.com/questions/56077747/how-to-select-a-named-range-in-google-sheets-query">this</a> and <a href="https://stackoverflow.com/questions/54729251/google-sheets-import-range-within-a-query">this</a> to no avail.</p>
  <p><strong>Problem</strong></p>
  <p>I don't want the header included. I tried relabelling it using the label function in query according to the required order. If this does not work, how do I retrieve the data without the label?</p>