The lack of pivot tables is really a miss. I did come up with a solution that does some javascript transformation of a data set (happy to share if anyone is interested) but pivot tables seem to be basic functionality that should be available in a data tool - especially since that is nothing that can be easily implemented via (standard) SQL