Arrayformula into INDEX&MATCH for googleform responses

user_15367504 0
Viewed 35

So basically, I just want to summarize or collapse into 1 column these 5 columns (B:F). My formula is in column G:G but it's not resulting as to my expectation (column H:H).

GoogleSheetFormula

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.

Can this be applied to a script instead of a formula?

Thank you in advance!

array-formulas google-sheets-formula google-apps-script
1 Answers

Try placing this formula in G1:

={
  "Class (summarize to 1 column)";
  ARRAYFORMULA(
    IF(
      A2:A = "",,
        TRIM(TRANSPOSE(QUERY(TRANSPOSE(B2:F),, 10^7)))
    )
  )
}
user_2798060
Related