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.

01

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.

02

From the drop down menu we could also select the command Paste Special.

03

The dialog box Paste Special appears, where we select the command Transpose and press the OK button as shown in the image below.

03a

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.

04

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.

Paste Transpose

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 19, 2012, in Excel 2010 English, Microsoft Office 2010 English and tagged , , , , , , . Bookmark the permalink. Comments Off on How To Use Paste Transpose.

Comments are closed.