Changing horizontal data to vertical
Spreadsheets are incredibly flexible. Within this huge and expandable grid of cells, there are really no restrictions on how you structure your data.
If the data needs to stay in that format for other people to use, you can transpose or copy it into a new table and use it as the basis for your Glide Project.
Transpose is a spreadsheet function that transforms a vertical range of cells to a horizontal range, or vice versa.
=TRANSPOSEto fix this. We’ll create a new table, and type =TRANSPOSE in the top-left cell.
Now we can select the range of data we want.
Now our rows are columns and our columns are rows — and we can use this data in Glide.