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     www.energyefficientbuild.com.    Oct 25, 2012 
user JG3674 said: (http://productforums.google.com/forum/?zx=r3nme9qg99cb#!category-topic/docs/spreadsheets/X9pE3W-YQQc)
How to transpose form results to new sheet?
Hi,

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.

Example:

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?

Thanks,

Jordan
---------------------------------------------------------------------------------------------------------------
following is a solution to the problem