Schemaninja logo

Schemaninja

How to Transpose in Excel?

Affiliate disclosure: In full transparency – some of the links on our website are affiliate links, if you use them to make a purchase we will earn a commission at no additional cost for you (none whatsoever!).

How nice it would be if one wants to transpose the data of a column to a row and could do in just a few steps? If you are wondering whether if any such method exists then, we are extremely glad to tell you that if you are working on Excel then you can easily do that.

So, let’s see how to transpose in Excel?

How to transpose in Excel?

The literal meaning of transpose is to “INTERCHANGE.” So, talking regarding the MS EXCEL function, it transposes the parameter given to it. For instance, if a horizontal range is given as a parameter, then the transpose function will return a vertical range as the output. It is basically a worksheet function.

The general syntax of transpose function goes as “Transpose (range).” The field signifies the range of the cells that one wants to transpose. Additionally, one must be aware of this fact that the range of the transpose function must be entered as in the form of an array.

So, in the following read, I’ll walk you through “How to convert a row to a column in Excel the easy way.” So, let’s get started:

Step #1: The first step is quite obvious. All that you require doing is to open the MS Excel application on your system. For this, you can consider the following way. Go to the start button, navigate to the all programs option, go the installed “Microsoft Office version” folder,   and select “Excel” from there. This way you can open MS Excel easily on your system.

How-to-transpose-in-excel

Now, you have to look for our next steps in order to proceed further.

Step #2: Now, you need to open any existing worksheet on which you want to perform the transpose action. Alternatively, you can open a blank workbook and then enter data just in order to get equipped with the knowledge of “How to use the transpose function?

How-to-transpose-in-excel

By now, you should have the data on which you want to perform the transpose function.

Step #3: Now, in this step, you need to select all those data which you want to transpose. Always remember that all the data should belong to a particular cell. Like if you are selecting data horizontally then you should not select any data vertically.

How-to-transpose-in-excel

Once you have selected the data, then you now need to copy it to the clipboard. For that, you can indeed use the keyboard shortcut “Ctrl + C.”

Now, look up for the next steps in order to transpose in excel.

Step #4: In this step, you now need to select the cell by which you want to transpose the chosen data. Been there, done that. If yes, then now right-click on that particular cell and select the “Paste Special” option.

How-to-transpose-in-excel

This activity of yours will open a window with some options. From that window, you are required to select “Transpose.” After this, you only require clicking on “OK.”

How-to-transpose-in-excel
How-to-transpose-in-excel

You will have the desired result in front of you.

[Additional Information]: How to use formulas in Excel?

Now, you know How to transpose data in excel? So, you are somewhat familiar with the use of functions in Excel. Since transpose is a function in itself so, we thought of making you equipped with the knowledge of how to use formulas in Excel? So, We urge you to pay heed to this additional section as the use of functions in Excel is quite stupendous. So, without wasting any time further, let’s get started:

Step #1: In order to get started, let us first see the basic syntax of an Excel function. The Excel function starts off with an equal sign, followed by the function name and then the arguments or parameters of that particular function.

So, it will look something like this: =SUM(A1: 1A2) which implies that we want to add the element one and two of cell A.

Now, we are aware of functions so, let’s move on to our primary concern which is to tell you how to use functions?

So, for this, you will have to open the Excel workbook on your system. You can consider the following way, click on start and type MS Excel and after the appropriate result appears, click on it and this will open the Excel application for you.

Noe, all that you require doing is to open the desired worksheet over which you can perform the basic operations using functions, in order to learn them. Or you can open a blank worksheet and enter some random values.

How-to-transpose-in-excel

Step #2: Now, let’s assume that you want to add elements of a cell using functions. In this step, we will tell you how to add values using the SUM function. So, all that you have to do is to click on the very next empty row, just below the last element.

Now, you need to click on the “fx” option. For your convenience, we have marked it red.

How-to-transpose-in-excel

Clicking on it will open a dialog box, from which you can select any of the predefined functions. But, as we want to add the elements so, we have to select “SUM.”

How-to-transpose-in-excel

From the subsequent window, you will be prompted to provide the argument or the parameters. Like, in this case, we want to add up all the elements of cell A. So, by default the parameters are A1: A4. However, you can change it if you wish. Once you are done all this stuff, then click on OK, and you will have your desired output in front of your screen as shown.

How-to-transpose-in-excel
How-to-transpose-in-excel

This way you can use any of the formulas in order to make your calculations a little easier.

So, this was all about How to transpose in Excel? We hope that after going through this very article, you must be able to do the desired work.

So, if you liked this article, then do let us know through the comments section down below. Additionally, do not forget to give us a thumbs up through our Facebook page and share this as much as possible.

Keep visiting and stay tuned for more of such informative articles.

arun singh

Arun Singh is a experienced server management geek and he has more than 8 years of experienced handling hosting server and he do sometimes share his knowledge in digital marketing. He currently with private company in Mumbai, India and he handles server management at BloggersIdeas.com.

Leave a Comment