Thursday, June 28, 2012

yogi_Cross Tab Comments By Store Name In Sheet Named Survey Comments From Sheet Named Form Data

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #601   Jun 28, 2012

user Grumpathy said:
Copying a column on data using another column as a criteria
I would like to find a way to pull all data from a column IF the data in another column matches a specific criteria. 
As an example:
I would like to pull the comments ('Sorted Data' column F) from a specific store ('Sorted Data' column A) and list them all together, so that I get all the survey comments from New York, all the survey comments from Atlanta, etc. 
Is there any way to do this?
in the following solution to the problem I have cross tabbed the comments directly from Form data sheet into Survey Comments sheet