Google Sheet - Query Function - missing from Microsoft Office

[Costas]

Runs a Google Visualization API Query Language query across data.

QUERY(A2:E6,"select avg(A) pivot B")

QUERY(A2:E6,F2,FALSE)

https://support.google.com/docs/answer/3093343