Runs a Google Visualization API Query Language query across data.
1
2
3
QUERY(A2:E6,"select avg(A) pivot B")
QUERY(A2:E6,F2,FALSE)
https://support.google.com/docs/answer/3093343
origin - http://www.pipiscrew.com/?p=5979 google-sheet-query-function-missing-from-microsoft-office