If your data is stored as text, you can use the "Spreadsheet spring to array" function with a suitable delimiter to convert to an array, then transpose it with "Transpose 2D array", and then "Array to spreadheet string" to convert back to text.
If your data is already in a 2D array, "Transpose 2D array" should do.
Martin