All language subtitles for 2. Transpose Function

Let us look at another function called transpose sometimes we want to change rows into columns or columns

in two rows we can do that using that transpose function.

For example I started entering this as column headers and then I realized that my data would not fit

properly into a vertical arrangement.

So I should create weekdays as horizontal row headings now instead of deleting everything and then re

typing.

I can just use that transpose function to convert the headings for columns into headings for rows let

us do that let's select cell A1 because this is where we'll insert Monday and then row two we'll have

Tuesday and so on and so forth.

From Luke up on their friends list we'll select transpose.

You can see it takes only one input which is the idea that you want to transpose so let us select the

cell range that we want to transpose now transpose is an array function which means it can return more

than one value.

In this case we have selected five cells here so this function needs to return five values vertically

if a click Okay.

You can see that this function did not work properly.

That's because the input and output ranges don't match.

So let us fix this problem

let us first select the range very one that transpose values the five values we have transposing in

the column so let's select five cells or five rows here then turn the function and we press control

plus shift plus enter when you press control shift and enter together you are telling Excel that you

are entering an array function here you can see that we selected five cells and the function has been

inserted and executed in all the five cells and you can see that Excel has put curly brackets in the

formula because it's an array function no.