title: Facing a difficulty in importhtml function, using order by and select col function but header is also being affected while importing in google sheets
body: <p>I am using this function
  <code>=QUERY(INDEX(SUBSTITUTE(IMPORTHTML (I2 &amp; &quot;?refresh=&quot; &amp; I6,I3,I4), &quot;*&quot;, )), &quot;SELECT Col1, Col2, Col3, Col4 ORDER BY Col1 ASC&quot;)</code></p>
  <p>This is returning data with the <strong>headers in between the table</strong>.</p>
  <p>Also, can we use offset to avoid headers at all, if yes what would be proper syntax
  Link to importing page</p>
  <p><a href="https://www.ipowatch.in/p/ipo-subscription-numbers-status.html" rel="nofollow noreferrer">https://www.ipowatch.in/p/ipo-subscription-numbers-status.html</a></p>