Lookup & Reference | How to Use Excel Transpose Function?



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?

Advertisements

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

  1. 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

excel transpose function

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

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

Realme 10 Pro and 10 Pro+ Launched RBI Monetary Policy Highlights England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence