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

How To Use in Sheets


External Links

11Better Sheets Tutorials


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.


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