VLOOKUP FOR 160+ COLUMNS

Hello Everyone

  1. I have created a form with 160+ questions in it
  2. then it was summarized in sheets ( see attached "FORM.png")
  3. Now that i have those answers , i want them to be summarized in another sheet in rows since the answers have corresponding points to it (see attached "row.png").
  4. y questionisre:. is there a way i could do it the faster way similar to a "transpose" function in excel?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!