Transpose

This function allows you to replicate the functionality of the Spreadsheet function "TRANSPOSE"

It takes a range in the spreadsheet and transposes it into another range, switching rows for columns.

So for example

1 2,3

4,5,6

7,8,9

would become

1,4,7

2,5,8

3,6,9