I tried this query string, but it's not working: =QUERY(Stories!1:1000, "select A,B,J,K group by J pivot K",1)
Can someone tell me why? On Monday, June 6, 2016 at 3:36:44 PM UTC-4, Melissa Zinder wrote: > > Hi! Here is the spreadsheet I'm referring to: > https://docs.google.com/spreadsheets/d/1VmlqVlh7OBj6hXL1C6Lpw2P5YDY9AdGzNGPqGQvMJi8/edit?usp=sharing > > I'm trying to make a pivot table of sorts with text, using the data from > the "Stories" tab. A template of the chart I'd like to make is on the > "Articles > by Magazine Date" tab. I'd like the headlines from the "Stories" tab that > correspond with each "Magazine Date" to be listed under their appropriate > "Magazine Placement" Category in the "Articles by Magazine Date" tab. Can > someone help? I've been trying to create a query, but I can't get it to > work. > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
