How To Use Paste Transpose
Sometimes we want to convert the rows to columns and the columns to rows in an Excel Workbook.
In Excel we can accomplish this in two different ways. In this post I will describe the easiest way first, which is less complex. In my next post I will describe the second way.
The less complex one, which is completed in a few keystrokes, is described below:
First we must select the table that we want to transpose and then from the Home tab and from the area of the ribbon named Clipboard we select the command Copy.
Once we have copied the selected area, we move the cursor to a cell in a blank part of our worksheet or even select a specific area. Then from the Home tab and from the area of the ribbon named Clipboard we select the arrow below the command Paste, in order for the drop down menu to appear as shown in the image below.
From the drop down menu we select the command Transpose as shown in the image below.
From the drop down menu we could also select the command Paste Special.
The dialog box Paste Special appears, where we select the command Transpose and press the OK button as shown in the image below.
One way or the other, our data has been transposed. We notice that the Headings of our Columns are now the Headings of our Rows, and what were the Headings of our Rows are now the Headings of our Columns.
The disadvantage of this sort of Transpose is the fact that the data of the two tables are not linked. For example if I change the data in a cell of the original table, nothing will get changed in the transposed version of the table.
As mentioned above I will describe in my next post, how to Transpose data that are linked between them.
You can also check out the video below, showing how we can use the Paste Transpose function in order to convert the columns and rows vice verca.
Posted on March 19, 2012, in Excel 2010 English, Microsoft Office 2010 English and tagged Excel 2010 Greek, MVP Office System. Columns To Rows, Office System, Paste Tranpose, Rows To Columns, Smart Office, Transpose. Bookmark the permalink. Comments Off on How To Use Paste Transpose.