Sunday, September 8, 2013

yogi_A Problem Of Rearranging Data Not Laid Out As List (Database)

                                          Google Spreadsheet   Post  #1364
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 08, 2013
user sureshrouniyar (http://productforums.google.com/forum/?zx=4z8gdni7rxvr#!category-topic/docs/spreadsheets/XtdfO4d5pww)
Could not be able to retrieve expected result after using query,import,sum pivot function
I have a problem that I have applied in Output Sheet in A1 does not split the data of Row 1 which I  had expected to be like in Row 12 to Row 13 from B12:G13.Pls help me in modifying the formula  either of Output Sheet of A1 or to breakup or splitting  Row 1 just expected just like into Row 12 to Row 13 after using a function-

=query(ImportRange("0Aml-557xsurxdDhFUXozRlkzWGJDZUhvcHNxN2JKVEE";"Sheet1!A2:D7");"select Col1,sum(Col4) group by Col1 pivot Col2,Col3")

Following is the link of spreadsheet for ur kind reference:

https://docs.google.com/spreadsheet/ccc?key=0Aml-557xsurxdDhFUXozRlkzWGJDZUhvcHNxN2JKVEE&usp=sharing

Thanks in advance.

With Best Rgds,

Suresh

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