QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Transpose in MS Excel 2016?

By Neha T Leave a Comment

Transpose is an array function i.e. it is applicable to arrays. There are two methods to perform the transpose first is Paste Special method, second Transpose function. The drawback with Paste special method is that if we perform any change in the source data it does not reflect in the transposed data. But if you are using Transpose function and perform any change in the source data it will reflect in the transposed data also. So, let us begin How to Transpose in MS Excel 2016?

Steps to Transpose in MS Excel 2016:

Find out that rows and columns to which you want to transpose. Now, in the image below you can see, I have data that shows the collection from the year 2011-2015 in all months. Where months data lies in rows and years data lies in columns.

how-to-transpose-in-ms-excel-2016But I want the years to be in rows and months to be in columns. For this, I have to apply transpose to the data.
As discussed above there are two methods to transpose in Excel. Let us start with Paste special:

Paste Special:

Step 1: Select the complete data that you want to transpose and Copy it.

how-to-transpose-in-ms-excel-2016-step-1Step 2: Right click your mouse and reach Paste Options, and search for the Transpose (T) button. If you fail to find it there, you can also search it in Paste Special options that appear just below the Paste Options. click on Transpose (T) button.

how-to-transpose-in-ms-excel-2016-step-2That all, your data would be transposed.

Transpose (array) Function:

Step 1:  You can see that I have already copy pasted the row and columns heading. This is only to get an idea of how many cells the transposed data will require. Now select all the cells that would store the transposed data.

how-to-transpose-in-ms-excel-2016-step-01Step 2: Then type =TRANSPOSE( ; and select the data array that you want to transpose. You can observe that the =TRANSPOSE (Cell 1 : Cell N  i.e. Transpose function automatically fills the cell code.

how-to-transpose-in-ms-excel-2016-step-002Step 3: After that close the TRANSPOSE function bracket and press Cntrl+Shift+Enter. You will see that all the data is transposed.

how-to-transpose-in-ms-excel-2016-step-003Thank You. Hope the content is useful. Keep reading.

You Might Also Like:

how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? Auto Fill in MS Excel 2016How to use Autofill in MS Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? Flash Fill in MS Excel 2016How to use Flash Fill in MS Excel 2016?

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to break Links in MS Excel 2016?
  • How to Create a HomeGroup in Windows 10
  • How to Create a Graph in Excel?
  • How to check and install java in Ubuntu 14.04
  • How to Hide Apps on iPhone?

Copyright © 2023 · QueHow · Contact Us