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