Glide HomepageOpen Glide

Getting Started

Quickstart
Intro to Layout
Intro to the Data Editor
Data to Layout
Intro to Actions
Intro to Workflows
App Settings
Templates

Essentials

Data Sources
Airtable
Big Tables
BigQuery
Getting Started with the Glide API
Glide Tables
Google Cloud SQL
Google Sheets
ARRAYFORMULAIMPORTRANGETRANSPOSE
Import File
Microsoft Excel
MySQL
PostgreSQL
SQL Server
Basic Columns
Components
Security and User Data
Users
Publishing and Sharing

Automation

Actions
AI
Computed Columns
Integrations
Workflows
View API Docs

Use Cases

Forms
Images in Glide
Conditions, Filtering, and Visibility
Duplicating Apps

Reference

Account
User Experience
Values
  • Data Sources
  • Google Sheets
  • TRANSPOSE

TRANSPOSE

Turn horizontal data to vertical, and vice versa.

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. Glide, however, likes data when it's more like a database, with the data organized in rows and columns. Sometimes, the way data is structured in your spreadsheet won't match this pattern. But that's not a problem.

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 app.

=TRANSPOSE

Transpose is a spreadsheet function that transforms a vertical range of cells to a horizontal range, or vice versa.

Transposing data in a Google Sheet.

Below, we have a set of reports. We want our app to treat each month as an item, but currently, our months are laid out in columns and the properties of that month are on the left.

Example repots from a Google Sheet.

We can use =TRANSPOSE to fix this. We'll create a new table, and type =TRANSPOSE in the top left cell.

Typing the =TRANSPOSE function.

Now we can select the range of data we want.

Selecting which data to transpose.

Now our rows are columns and our columns are rows, and we can use this data in Glide.

The view after the data has been transposed.

Have a question about TRANSPOSE? Ask the Glide community.
Need more help? Hire an Expert.

Updated more than a week ago

Previous

IMPORTRANGE

Next

Import File

Was this article helpful?
Exit Preview Mode