David Cook (davidcook) wrote,
David Cook
davidcook

  • Mood:

Geeky Excel thought ...

The other day, I realised that Excel's so-called "PivotTables" are just dressed-up SQL Select / Group By expressions.
I wish they'd just explain them that way in the first place, rather than leaving them as vaguely defined possibly-useful things.

(Also wish they'd picked a different name, because "pivot" is a term for a standard matrix operation, and I kept running across the Excel kind when I was searching for the matrix kind).
Subscribe

  • Books read in 2017 ...

    Angel of Storms - Trudi Canavan The Rhesus Chart - Charles Stross Magic for Nothing - Seanan McGuire The Annihilation Score - Charles Stross An…

  • DW and LJ

    In case anyone is looking for me on Dreamwidth, same username as on LJ (since, ummm ... 2009 !) Original post on Dreamwidth - there are…

  • Movies in 2015 ...

    Well, I'm cheating a bit, because I only saw one at the cinema, Star Wars: The Force Awakens, but I want to note down a few thoughts I had on it ...…

  • Post a new comment

    Error

    default userpic
    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 2 comments