Transposing Cells in Excel 2007

Transpose is the function that we can use to convert the horizontal range into vertical range and vertical range into horizontal range in Microsoft Excel.

In Microsoft Excel we have 2 ways of Transpose the data.

  • Transpose Function
  • Transpose option

Let’s take an example and understand how we can use transpose function?

We have name list in a column and we want to update it in row. How do we do it through Transpose function?

 

image 1

 

Follow below steps:-

  • First count cells of the range -its 12.
  • Then select 12 cells in vertical range.

 

image 2

 

  • Press the key F2.
  • Enter the function =TRANSPOSE(A2:A13)

 

image 3

 

  • Press Ctrl+Shift+Enter.
  • Columns’ text will get updated in the selected row.

 

image 4

 

In this way, we use Transpose function in Microsoft Excel.
 
How to use Transpose Option to convert the data from Vertical to horizontal and vice versa?

You will find this option under the Paste Special option. Now we will see how we can use this option to convert the range’s position.

Follow below steps:-

  • Select the range that we want to convert.

 

image 5

 

  • Copy the range by pressing the key Ctrl+C.
  • Select the cell where you want to paste the data.
  • Right click with the mouse.
  • You will see the Pop-up.

 

image 6
 

  • Select Paste-Special option.
  • Paste Special dialog box will appear.
  • Click on Transpose.

 

image 7

 

  • Data will get converted from Vertical range to horizontal range.

 

image 8

 

This is called Transpose and these are the ways to use the Transpose function and Option in Microsoft Excel.
 
Below you can find more example to learn about Transpose:-

How to transpose cells in Microsoft Excel

How to transposing Values from Columns into Rows, and Vice Versa

How to use Transpose function

How to Copy Vertical and Paste Horizontal in Microsoft Excel

 

image 48
 
If you liked our blog, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us @ info@exceltip.com

 

 

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.