Wednesday, April 18, 2012

yogi_Pivot The Data In A Table And Reconfigure Per Specification

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #508    Apr 18, 2012     www.energyefficientbuild.com.

user Dark_tower said:
Row problem with Form Submissions

Here's what I've got.
Group of people; For instance
John
Joe
Jane
Julie
Each person has a list of things to do;
Modules
1
2
3
4
(there are a LOT more people and a LOT more modules).
What I'm trying to do is make it so where, each submission will add to or create a column on the same row as the first submission.
EG: John Completed Module 1
Upon Johns next submission, instead of adding a new row that says John : Completed Module 2, I am trying to get it to place the word "Yes" into the column that is labeled "Module 2".
Regardless which item type I use, it always adds a new row, is there a way around this?
Example.
Name       Module 1     Module 2
John           Yes               Yes
instead of
Name     Module 1     Module 2
John           yes
John                              yes
or 
Name     Module
John           1
John           2
-----------------------------------------------------------------------------------
following is a solution to the problem