{"id":697,"date":"2011-05-17T18:34:28","date_gmt":"2011-05-18T01:34:28","guid":{"rendered":"https:\/\/accretiondisc.com\/blog\/?p=697"},"modified":"2011-05-18T07:41:07","modified_gmt":"2011-05-18T14:41:07","slug":"pivot-tables-in-google-docs","status":"publish","type":"post","link":"https:\/\/accretiondisc.com\/blog\/2011\/05\/17\/pivot-tables-in-google-docs\/","title":{"rendered":"Pivot Tables in Google Docs"},"content":{"rendered":"<p><a href=\"http:\/\/googledocs.blogspot.com\/2011\/05\/summarize-your-data-with-pivot-tables.html\">This is amazing<\/a>. I used to use Pivot Tables on a daily basis, but the last two versions of Excel have made them inexplicable to me. These days, if I need a Pivot Table, I save the spreadsheet table as <a href=\"http:\/\/en.wikipedia.org\/wiki\/Comma-separated_values\">CSV<\/a> data, <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/mysqlimport.html\">import it<\/a> into MySQL, and then do SQL <a href=\"http:\/\/en.wikibooks.org\/wiki\/MySQL\/Pivot_table\">queries there to produce a pivot table<\/a>. But now I might have to try it in my browser instead:<\/p>\n<p><iframe loading=\"lazy\" width=\"560\" height=\"349\" src=\"http:\/\/www.youtube.com\/embed\/giuD7KSmock\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is amazing. I used to use Pivot Tables on a daily basis, but the last two versions of Excel have made them inexplicable to me. These days, if I need a Pivot Table, I save the spreadsheet table as CSV data, import it into MySQL, and then do SQL queries there to produce a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[52],"tags":[197,225,313,227],"class_list":["post-697","post","type-post","status-publish","format-standard","hentry","category-technology","tag-google","tag-googledocs","tag-pivot-tables","tag-spreadsheet"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRqpr-bf","_links":{"self":[{"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/posts\/697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/comments?post=697"}],"version-history":[{"count":0,"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/posts\/697\/revisions"}],"wp:attachment":[{"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/media?parent=697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/categories?post=697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/accretiondisc.com\/blog\/wp-json\/wp\/v2\/tags?post=697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}