title: Index - Offset - Array Formula
body: <p>I am using OFFSET function to transpose the "Question" columns to rows so every row would correspond to a Link/Question combination as shown in the 2nd table. </p>
  
  <p>I can hide values in columns A &amp; B if column C is blank but this is taking TOO MUCH space in my table (<em>my full data consist of 11 questions, and hundreds of rows, which won't fit in my sheet if I create a row for every Question column</em>). I need to transform my functions to an array formula that would only populate a row for every Link/non blank Question combo, so that row 9 in the image below won't show up and its formula won't exist at all. I'm using Gsheets.<a href="https://i.stack.imgur.com/lyBgX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lyBgX.png" alt="enter image description here"></a></p>
  
  <p>1st function for column A
  2nd function for column C</p>
  
  <pre><code>OFFSET($A$2,FLOOR((ROW($A1)-ROW($A$1))/2,1),0)
  OFFSET($C$2,FLOOR((ROW(A1)-ROW($A$1))/2,1),MOD((ROW(A1)-ROW($A$1))/2,1)*2)
  </code></pre>