title: Show the first non blank cell of a table
body: <p>I am importing data with ImportJSON from Yahoo Finance of different stocks. It is the first table at the top, that's showing some data about different parameters.</p>
  <p>The problem is that due to some paths have several rows of data, the table has many rows.</p>
  <p>I want to have a unique row taking the first value of each column, like in the middle's table. I can't use several ImportJSON due to Url Fetch Calls limits because it will be done with several stocks.</p>
  <p>I don't know how to start. I would be glad if someone can resolve it.</p>
  <p>I need to resolve with <strong>one formula</strong> or with <strong>some code</strong> <strong>both ImportJSON() and the way to get the final result</strong>, without any helpers cells.</p>
  <p>The bottom table is the result I want to have after the formula / script is done.</p>
  <p>Watch out not all stocks have the same amount of rows.</p>
  <p><a href="https://i.stack.imgur.com/DyuS8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DyuS8.png" alt="enter image description here" /></a></p>
  <p>I've left you the spreadsheet.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/15BhgDmGEUuPGiJWKGSPE6ycqok8MknK82Wv6i7MC1o0" rel="nofollow noreferrer">Spreadsheet</a></p>
  <p>Thanks in advance.</p>