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

------------------------------------------------------------------------------------------------------------------------------------------------------