{"id":95034,"date":"2025-08-22T13:31:00","date_gmt":"2025-08-22T17:31:00","guid":{"rendered":"https:\/\/bugaluu.com\/sapiosexual\/query-function-google-docs-editors-help-2\/"},"modified":"2025-08-22T13:31:00","modified_gmt":"2025-08-22T17:31:00","slug":"query-function-google-docs-editors-help-2","status":"publish","type":"post","link":"https:\/\/bugaluu.com\/sapiosexual\/query-function-google-docs-editors-help-2\/","title":{"rendered":"QUERY function &#8211; Google Docs Editors Help"},"content":{"rendered":"<p>QUERY function Runs a Google Visualisation API Query Language query across data. Sample usage QUERY(A2:E6,&#8217;select avg(A) pivot B&#8217;) QUERY(A2:E6,F2,FALSE) Syntax QUERY(data, query, [headers]) data \u2013 The range of cells to perform the query on. Each column of data can only hold boolean, numeric (including date\/time types) or string values.<\/p>\n<p><a href=\"https:\/\/support.google.com\/docs\/answer\/3093343?hl=en-GB\" target=\"_blank\" class=\"\">https:\/\/support.google.com\/docs\/answer\/3093343?hl=en-GB<\/a>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>QUERY function Runs a Google Visualisation API Query Language query across data. Sample usage QUERY(A2:E6,&#8217;select avg(A) pivot B&#8217;) QUERY(A2:E6,F2,FALSE) Syntax QUERY(data, query, [headers]) data \u2013&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-95034","post","type-post","status-publish","format-standard","hentry","category-sapiosexual","wpcat-1-id"],"_links":{"self":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/95034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/comments?post=95034"}],"version-history":[{"count":0,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/95034\/revisions"}],"wp:attachment":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/media?parent=95034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/categories?post=95034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/tags?post=95034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}