Transpose and Split Data into new Sheet

I am looking to transpose and split data into a new table in Glide. However, I am having trouble on what the best way to do so would be. Attached below is my current sheet.

I was able to do it in a google sheets, and the formula was =transpose(split(Sheet1B2, β€œ,”).

Thank you.

First you need to create a row number (see link below). To transpose you need to use a single value column with the configuration: get from start, and the row follows your row index number of the array column you want to transpose.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.