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

Data Analysis

  • How to Create One and Two Variable Data Tables in Excel
  • Subtotal function in Excel
  • How to Create Thermometer Chart in Excel
  • How to create Gauge Chart in Excel
  • How to Create Gantt Chart in Excel

References

  • How to get last row in text data in Excel
  • How to get first row number in range in Excel
  • Two-way lookup with VLOOKUP in Excel
  • Perform case-sensitive Lookup in Excel
  • Excel Advanced Lookup using Index and Match Functions

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation date in next 30 days
  • Prevent invalid data entering in specific cells
  • Excel Data validation allow weekday only
  • Excel Data validation date in specific year

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.

Worked Example:   Index and match on multiple columns in Excel

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.

Worked Example:   Count rows that contain specific values in Excel

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.

Worked Example:   Count rows with at least n matching values
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:

MDETERM function: Description, Usage, Syntax, Examples and Explanation

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

  • SWITCH function example in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel FALSE Function
  • Extract multiple matches into separate rows in Excel
  • Invoice status with nested if in Excel

Date Time

  • Convert text timestamp into time in Excel
  • Display Date is same month in Excel
  • Get project midpoint in Excel
  • How to calculate workdays per month in Excel
  • Display Days until expiration date in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • Map text to numbers in Excel
  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel

General

  • How to get Excel workbook path only
  • 44 Practical Excel IF function Examples
  • How to calculate percent change in Excel
  • List worksheet index numbers in Excel
  • Lock Cells in a Worksheet Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning