Cellgrids Cellgrids
Home › Excel formulas › Lookup and Reference › TRANSPOSE

TRANSPOSE Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

TRANSPOSE is an Excel Lookup & Reference function. Flips a range from rows to columns or vice versa.

TRANSPOSE syntax

=TRANSPOSE(array)

Arguments

When to use TRANSPOSE

TRANSPOSE is used to pull matching data from one part of a workbook into another.

Practice TRANSPOSE online, free

Open the live Excel-style spreadsheet and try TRANSPOSE yourself. No Excel install or sign-up needed to start.

Practice TRANSPOSE now →

Learn more

Read the tutorial: How to transpose data.

More Lookup & Reference functions

Frequently asked questions

What does the TRANSPOSE function do in Excel?

Flips a range from rows to columns or vice versa.

What is the syntax of TRANSPOSE in Excel?

The syntax is =TRANSPOSE(array). array: The range or array to evaluate.

Where can I practice TRANSPOSE online for free?

Open the free live spreadsheet on Cellgrids and try TRANSPOSE yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts