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

Data Analysis

  • How To Create Pareto Chart in Excel
  • How To Create Frequency Distribution in Excel
  • How to Create Column Chart in Excel
  • Example of COUNTIFS with variable table column in Excel
  • Error Bars in Excel

References

  • Approximate match with multiple criteria in Excel
  • Count unique text values with criteria
  • To count total rows in a range in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Left Lookup in Excel

Data Validations

  • Excel Data validation only dates between
  • Excel Data validation don’t exceed total
  • Prevent invalid data entering in specific cells
  • Excel Data validation allow weekday only
  • Excel Data validation specific characters only

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.

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.

1. First, select the new range of cells.

2. Type in =TRANSPOSE(

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

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:

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

  • Extract multiple matches into separate rows in Excel
  • IF with wildcards in Excel
  • How to return blank in place of #DIV/0! error in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Roll back weekday to Friday base on a particular date in Excel
  • Convert decimal minutes to Excel time
  • Convert time to time zone in Excel
  • How to join date and text together in Excel

Grouping

  • Categorize text with keywords in Excel
  • Calculate conditional mode with criteria in Excel
  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel
  • If cell contains one of many things in Excel

General

  • Share Excel data with Word documents
  • How to create dynamic worksheet reference in Excel
  • Basic numeric sort formula in Excel
  • 3D SUMIF for multiple worksheets in Excel
  • How to get original price from percentage discount in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning