Thursday, October 25, 2012

yogi_Create A SisterSheet In Which Select Fields From Form Resposes Sheet As Specified By User Are Transposed

                                           Google Spreadsheet   Post  #825
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Oct 25, 2012 
user JG3674 said: (!category-topic/docs/spreadsheets/X9pE3W-YQQc)
How to transpose form results to new sheet?

I am looking to transpose data from a google form.  It is a little tricky as the first few form columns are static but the last 12 will vary after each submission.


When the form gets submitted we have data in Columns A, B, C, D, E, F

I would like it to be transposed on Sheet 2 like this

A, B, C, D

A, B, C, E

A, B, C, F

Is this possible?


following is a solution to the problem