title: Arrayformula into INDEX&MATCH for googleform responses
body: <p>So basically, I just want to summarize or collapse into 1 column these 5 columns (<code>B:F</code>).
  My formula is in column <code>G:G</code> but it's not resulting as to my expectation (column <code>H:H</code>).</p>
  <p><img src="https://i.stack.imgur.com/IhVss.png" alt="GoogleSheetFormula" /></p>
  <p>I want the array effect so that I don't need to drag the formula down every time a user submits a a response in google form.</p>
  <p>Can this be applied to a script instead of a formula?</p>
  <p>Thank you in advance!</p>