Instead, you should press CTRL+SHIFT+ENTER. Make sure you do not press ENTER after inserting the Transpose Formula because the Transpose function is an Array function.Make sure you select the same number of blank cells as the number of cells in source information while using the Transpose Formula.
So after hitting the CTRL+SHIFT+ENTER, you will be able to see the result as below.Īs you can see, Raj and Vikas scored less than 50, so they are marked as FAIL. So we can use transpose Formula with IF condition like below.īut make sure not to press ENTER and press CTRL+SHIFT+ENTER.
You want to transpose the information with the condition that those who score below 50 or absent should be marked as Fail. Suppose you have a report card of few students available in the Horizontal orientation. So let’s try to use this with the IF Condition formula. The transpose function can be used with other functions to get the desired results.
#Microsoft excel transpose cells how to#
Please refer to the below screenshot on how to do this. Now be careful with this step because you need to insert the TRANSPOSE Formula in Cell A6 while all the blank cells still selected.As you can see in the below screenshot, I have selected 24 blank cells in the Vertical direction.
So in our example, we need to select 24 cells in the opposite direction.
So to avoid that, we can use the TRANSPOSE function in excel. So we have seen how to swap orientation with the help of the copy and paste feature, but there is a risk of creating duplicated data. Now you will see the information is pasted in a vertical manner.So that it can paste the data with formulas, and it can swap the information from Horizontal to vertical and then click on OK. In addition to the formula button, click on the Transpose button as well.In this case, I am selecting Formulas because I need the data with formulas.Select Values if you just want to copy the values of data and select Formulas if you want to copy the data with Formulas. In the paste area, there are two important options (Values and Formulas). Also, there is an additional option for Skip Blanks and Transpose. As you can see, there are multiple options for Paste & Operation.After the paste special values, you will see the below options.Copy the Table (CTRL+C) and go to another sheet (or anywhere in the excel sheet where you want the information) and Paste special values (CTRL+ALT+V).Select the range of information that you need to swap or switch.Now to switch or swap the information from Horizontal to Vertical, we will need to follow the below steps.