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

11Better Sheets Tutorials

1

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.
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.
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Track your goals with a thermometer.
Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.

10

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.