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

Data Analysis

  • Remove Duplicates Example in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • Conditional Formatting Rules in Excel
  • How To Load Analysis ToolPak in Excel

References

  • How to use Excel VLOOKUP Function
  • How to use Excel LOOKUP Function
  • How to create dynamic named range with OFFSET in Excel
  • How to use Excel INDIRECT Function
  • Count unique text values with criteria

Data Validations

  • Excel Data validation with conditional list
  • Excel Data validation no punctuation
  • Excel Data validation date in specific year
  • Excel Data validation only dates between
  • Excel Data validation exists in list

Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel

by
  • Paste Special Transpose
  • Transpose Function

Use the ‘Paste Special Transpose’ option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.

Paste Special Transpose

To transpose data, execute the following steps.

Worked Example:   Understanding Various Paste Options in Excel

1. Select the range A1:C1.

2. Right click, and then click Copy.

3. Select cell E2.

4. Right click, and then click Paste Special.

5. Check Transpose.

6. Click OK.

Transpose Function

Also, TRANSPOSE function returns a vertical range of cells as a horizontal range, or vice versa.

To insert the TRANSPOSE function, execute the following steps.

Worked Example:   How To Multiply Numbers in Excel

1. First, select the new range of cells.

2. Type in =TRANSPOSE(

3. Select the range A1:C1 and close with a parenthesis.

Worked Example:   How to calculate percent variance in Excel

4. Finish by pressing CTRL + SHIFT + ENTER.

Note: The formula bar indicates that this is an array formula by enclosing it in curly braces {}. To delete this array formula, select the range E2:E4 and press Delete.

Post navigation

Previous Post:

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

Next Post:

Everything about Charts 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 return blank in place of #DIV/0! error in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel AND Function
  • Extract multiple matches into separate rows in Excel

Date Time

  • How to calculate next anniversary date or birthday in Excel
  • Get first day of month in Excel
  • Get last weekday in month in Excel
  • How to calculate project start date based on end date in Excel
  • How to determine year is a leap year in Excel

Grouping

  • Map inputs to arbitrary values in Excel
  • Group numbers with VLOOKUP in Excel
  • Group numbers at uneven intervals in Excel
  • Running count group by n size in Excel
  • Group arbitrary text values in Excel

General

  • Basic text sort formula in Excel
  • Create dynamic workbook reference to another workbook in Excel
  • Hide and Unhide Columns or Rows in Excel
  • How to calculate decrease by percentage in Excel
  • How to calculate percent of students absent in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning