In the previous post, we saw ‘Text Function | How to use the Excel SUBSTITUTE Function?, now we will learn about how to use the Excel TRANSPOSE Function?‘.
Where to Find the Lookup & Reference Function?
To find the Lookup & Reference function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Lookup & Reference’ option as shown below:
You can also see the Lookup & Reference function via shortcut key – press ‘ALT + M + O’ after that select the lookup & Reference function that you want to use.
What is Excel Transpose Function?
The Excel Transpose function converts the vertical range of cells to the horizontal range or vice versa.
Syntax
TRANSPOSE(array)
Arguments
The TRANSPOSE function syntax has the following argument:
array Required. An array or range of cells on a worksheet that you want to transpose. The transpose of an array is created by using the first row of the array as the first column of the new array, the second row of the array as the second column of the new array, and so on.
Understand With Example
- First copy the data using ‘CTRL +C’ then come to blank cell where you want to paste it.
2. Press ‘CTRL + ALT + V’ after that press ‘E’ and hit the enter button
You can convert horizontal data into vertical format repeat the same steps.
If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.
The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function
For Latest Updates & Learning Join Our YouTube Channel: Join Now