Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Randomize/ Shuffle List in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Chart Axes in Excel

References

  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Extract all partial matches in Excel
  • Perform case-sensitive Lookup in Excel
  • Merge tables with VLOOKUP in Excel
  • Multi-criteria lookup and transpose in Excel

Data Validations

  • Excel Data validation number multiple 100
  • Excel Data validation must contain specific text
  • Excel Data validation exists in list
  • Excel Data validation only dates between
  • How To Create Drop-down List in Excel

How to use Excel TRANSPOSE Function

by

This Excel tutorial explains how to use the TRANSPOSE function with syntax and examples.

Excel TRANSPOSE Function Description

Microsoft Excel TRANSPOSE function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.

TRANSPOSE function is a built-in function in Excel that is categorized as a Lookup/Reference Function. The TRANSPOSE function can be entered as part of a formula in a cell of a worksheet.

Explanation:  The TRANSPOSE function converts a vertical range of cells to a horizontal range of cells, or a horizontal range of cells to a vertical range of cells. Use it to “flip” a range of cells from one orientation to another.

Syntax

The syntax for the TRANSPOSE function in Microsoft Excel is:

TRANSPOSE( range )

Arguments

range
The range of cells that you want to transpose.

Returns

The TRANSPOSE function returns a transposed range of cells.

Note: The range value in the TRANSPOSE function must be entered as an array. For a one-off conversion, you can use paste special > transpose. To enter an array, enter the value and then press Ctrl+Shift+Enter. This will place {} brackets around the formula, indicating that it is an array.

Post navigation

Previous Post:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use IFS function in Excel
  • IF with boolean logic in Excel
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel

Date Time

  • Add workdays no weekends in Excel
  • DAYS function: Description, Usage, Syntax, Examples and Explanation
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Sum race time splits in Excel
  • Display Date is workday in Excel

Grouping

  • Map text to numbers in Excel
  • Map inputs to arbitrary values in Excel
  • If cell contains one of many things in Excel
  • Group arbitrary text values in Excel
  • Group times into 3 hour buckets in Excel

General

  • Automatically fill series of cells in Excel using AutoFill
  • How to calculate percent variance in Excel
  • How to choose page/paper size in Excel before Printing
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Check if multiple cells have same value in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning