Transpose in excel – A simple technique to save your valuable time

Transpose in excel – A simple technique to save your valuable time
5 (100%) 5 votes

Transpose in excel – Simple technique to save your time

Transpose in excel is a simple but powerful technique to rotate your data in MS excel. This article will help those who are beginners in MS excel. Someone who is new in MS excel will like this technique and learnt it immediately. Please share the post if you like it.

Suppose you have data in vertical cells and you want to convert it into a horizontal row, then you can make use of transpose in excel.

I strongly recommend you to read the last section “How to use transpose function in SAP”, where I have given an example to explain the application of transpose function in SAP.

before that let us learn transpose function step by step:

Step 1: Suppose you have data in MS excel in vertical column. Please refer below screen shot.

Transpose

Step 2: Now you want to rotate this vertical column into horizontal row. First copy this data. Use Ctrl + C. Do not use Ctrl+X. Ctrl+X will not work here.

Transpose1

 

Step 3: Then select the cell where you want to paste the data. Once cell is selected, click right button of your mouse (right click).

 

Right Click

Then click on the icon highlighted in above screen shot. Or else click on the Paste special option just below the icon.

Step 3: A new pop window will appear. Please check below sequence of screen shots.

 

 

Paste Special1 transpose check box

Step 4: Here is the result.

transpose result

 

How to use transpose function in SAP

It is would be very interesting to know where to apply transpose function while working in SAP. There are number of instances where we can use this function. However, I am taking a small example of LSMW. While working on LSMW, in the source filed screen we get all the fields vertical (please refer below screen).

LSMW screen shot

If we want to prepare a template to upload data, then we will have to copy it and and paste it into an MS excel sheet (refer below screen shot).

LSMW in MS excel

Afterwards, we will have to apply the transpose function in ms excel to rotate the fields horizontally.

transpose in excel

 

As you can see the above screen shot all the fields are now horizontal.

transpose result1

Hope you liked this post. Please share it on social network and share the knowledge.

 

Vaibhav

Author: Vaibhav

Vaibhav is an engineer by schooling and an SAP Consultant by training with 12 years of experience. He is certified in SAP PM and SAP MM. His expertise includes SAP PM, SAP MM, SAP QM, and MS excel. His industry specialties are Chemical, Automobile, Electronics and Infrastructure. He has lots of experience in SAP Training and Consulting.

How drop down list in excel can help you?   Almost every SAP consultant had
Learn IFERROR in excel in less than 5 minutes Time to say good bye to #N/A,
5 Effortless tricks to handle Duplicates in Excel This is going to be the most
Shortcut keys in MS excel to improve your efficiency at work   Here is another
Innovative use of AutoCorrect option in MS Excel You must be wondering after reading the

No Comments

Leave a Reply

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

error: Content is protected !!