Formulas > =TRANSPOSE()

How To Use TRANSPOSE() Function in Google Sheets

Description

Transposes the rows and columns of an array or range of cells.

How To Actually Use TRANSPOSE() in Sheets

TRANSPOSE(array_or_range)

Try TRANSPOSE yourself

Use the TRANSPOSE function to switch the rows and columns of the range A1:B3. Place your formula in cell D1.

Hints (2)

16 Better Sheets Tutorials

Create a Sheet of Sheets for Project Management and/or Data Management

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!
COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()
Make a Quick Pipeline (For Sales and More)

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.
TRANSPOSE() UNIQUE()
Creating A Dark Mode Theme | Announcing Dark Habits

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +6 more
Deep Inside Dark Habits Google Script

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.
ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +3 more
Build a Thermometer for Savings Goals

Build a Thermometer for Savings Goals

Track your goals with a thermometer.
CONCATENATE() IF() REPT() ROUND() SPLIT() +1 more
Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.
INDIRECT() SORT() TRANSPOSE()
Organize Anything! - Build a Kanban Board / Trello Board

Organize Anything! - Build a Kanban Board / Trello Board

Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.
COUNTA() FILTER() TRANSPOSE() UNIQUE()
Create a Many to Many Database

Create a Many to Many Database

We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.
FILTER() IFNA() JOIN() TRANSPOSE()
This Seems Like Automation

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
FILTER() FLATTEN() IF() IFERROR() TRANSPOSE() +1 more
Allow Multiple Selections is in Google Sheets Yay!

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!
FILTER() IFNA() JOIN() SEARCH() SPLIT() +1 more
5 Ways To Use Google Sheets for Advanced Project Management

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script
COUNTIF() FILTER() IF() INDEX() ISBLANK() +3 more
Tagging Titles, Create a Comma Separated List of Tags

Tagging Titles, Create a Comma Separated List of Tags

The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.
COUNTIF() FILTER() JOIN() TRANSPOSE()
Create a Trello Board with Transpose Formula in Google Sheets

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.
TRANSPOSE()
Your First Formula

Your First Formula

Learn how to use Formulas in Google Sheets. Use the Equal sign "=" to unlock a magical portal of over 500 functions and formulas. Learn one cool trick that even experts might not know about formulas.
CONCATENATE() TRANSPOSE()
Turn Headlines up to 11! - Update to Spintax Tool

Turn Headlines up to 11! - Update to Spintax Tool

Updated the Spintax tool to allow you to generate Spintax. Instead of having to come up with it all yourself, you can let AI generate the Spintax for you. Create variations on headlines, or phrases, or emails.
CONCATENATE() IF() JOIN() TRANSPOSE()
Pick a Raffle Winner with Number of Tickets

Pick a Raffle Winner with Number of Tickets

Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.
ARRAYFORMULA() IF() INDEX() JOIN() RANDBETWEEN() +3 more

Learn more about the TRANSPOSE() formula:

Generate a TRANSPOSE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses TRANSPOSE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a TRANSPOSE() formula