Transpose and Split Data into new Sheet

[jmueland]

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.

[Himaladin]

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.

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…