Monday, September 2, 2013

yogi_Consolidate Data From Series Of Multiple Columns With Similar Attributes In A Summary Sheet (yogi_Results)

                                          Google Spreadsheet   Post  #1355
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 02, 2013
user Tom Shevock (http://productforums.google.com/forum/?zx=iipnhccd9iao#!mydiscussions/docs/J_ylGaGYih0)
How do I transpose part of a spreadsheet with grouped columns?
Here is the sheet I have as a result of a Google Form...(Columns)

A, B, C, D, E, ..... AF, AG, AH, AI           all in one spreadsheet row.  An unknown number of rows will be created.

Here is what I need for each row from above...

A, B, C, D, E, F
A, B, C, G, H, I
A, B, C, J, K, L
...
A, B, C, AG, AH, AI
and then repeat for the next form row.

Seems straight forward but haven't found a way to do it.

Any help would be appreciated.
Tom
---
Here is a link to the spreadsheet.  https://docs.google.com/spreadsheet/ccc?key=0Ak1t-W4jJzB0dHltMW9iWHFHeXBLV3BrZDkwTmpWOGc&usp=sharing
Sheet2 A1 has the query that Kishan has suggested but it is not working.
the "Hoped for Result" sheet shows what I hope to get from the input of the form (Sheet1) and it should continue as new lines are added to the form
If there is no entry for Photograph-Title then no row should be created because the photographers can enter between 1 and 10 photos into the competition.

Thank you for your help.
Tom
------------------------------------------------------------------------------------------------------------------------------------------------------