TRANSPOSE()

Description

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

How To Use in Sheets

TRANSPOSE(array_or_range)

External Links

MMULT & TRANSPOSE

Google Docs Help

11Better Sheets Tutorials

FREE

Your First Formula

Beginner

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.

Create a Trello Board with Transpose Formula in Google Sheets

Intermediate Most Popular

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.

Creating A Dark Mode Theme | Announcing Dark Habits

Intermediate Most Popular

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Deep Inside Dark Habits Google Script

Make a Quick Pipeline (For Sales and More)

Beginner

Build a Thermometer for Savings Goals

Intermediate

Track your goals with a thermometer.

Tagging Titles, Create a Comma Separated List of Tags

Intermediate

Create categories