For example, QUERY [1], SPLIT [2] and ARRAYFORMULA [3] are the ones that comes to mind. To be fair MS Excel can do arrayformulas, but I prefer GSheet's syntax.

For example, QUERY [1], SPLIT [2] and ARRAYFORMULA [3] are the ones that comes to mind. To be fair MS Excel can do arrayformulas, but I prefer GSheet's syntax. Last time I tried Excel, TRANSPOSE wasn't a thing it but it seems to be there now. [1]: https://support.google.com/docs/answer/3093343 https://support.google.com/docs/answer/3093343 [2]: https://support.google.com/docs/answer/3094136 https://support.google.com/docs/answer/3094136 [3]: https://support.google.com/docs/answer/3093275 https://support.google.com/docs/answer/3093275