title: Using Google Sheet Formula IMPORTXML to extract hyperlinks from table on web page, and flag when an image is in seperate column
body: <p>I'm doing some analysis which requires me to save table data and (hyperlinked) links to lots of PDF's from a webpage (<a href="https://www.asx.com.au/asx/v2/statistics/prevBusDayAnns.do" rel="nofollow noreferrer">https://www.asx.com.au/asx/v2/statistics/prevBusDayAnns.do</a>).</p>
  <p>I've been playing around with the <code>=IMPORTHTML</code> and <code>=IMPORTXML</code> formulas in Google Sheets and have managed to extract the table data using <code>=IMPORTHTML(A1,&quot;table&quot;,1)</code>, but I'm struggling to extract the &quot;Price sens.&quot; column which contains images or the hyperlinks attached to the &quot;Headline&quot; items. I'm having no luck with <code>IMPORTXML</code> so far, and can't seem to find any solutions online.</p>
  <p><a href="https://i.stack.imgur.com/5dwdi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5dwdi.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/XyZC2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XyZC2.png" alt="enter image description here" /></a></p>