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


  1. This works great! Thank you very much!

  2. You Are Very Welcome Grump Athy ... Now Let Us Keep Googling.

    Cloud Computing -- Google Docs Way