Secret use of Transpose Function in Excel-Convert Columns into Rows
transpose function in excel, transpose formula, transpose function as part of an array,transpose formula row to column in excel,transpose function google sheets,transpose formula hindi,transpose in excel with formula,transpose formula horizontal to vertical,transpose function casio,transpose function derivative,transpose function r studio,transpose function youtube,understanding transpose formula
Category
📚
LearningTranscript
00:00This video will be very useful for Excel users.
00:19In this video, we will discuss a very important function of Excel, which is known as transpose
00:26function.
00:28And let's discover its magic use.
00:32So here is the Excel workbook in front of you.
00:36And I am going to be convert all these column values into the horizontal row values.
00:46So just start this one by using this one by selecting all the relevant cells and then
00:55apply the transpose function by applying equal sign and then transpose.
01:01After that, you will select all these values and then close parenthesis.
01:07Here is the very important step that you have to remember.
01:12After this, you have to be click or press ctrl shift enter simultaneously ctrl shift
01:20enter.
01:21So you see all the selected cells automatically filled by this formula.
01:28So here, I want to show that this transpose function has been turned into the array.
01:35And you see at this stage, I am going to show you here, there is a curly bracket before
01:44both the end of this function.
01:47So this shows that this curly bracket turns this transpose function into the array function.
01:53I hope you will find this video useful.
01:55If you like this one, please hit the like button and subscribe my channel and don't
02:03forget to hit the bell icon button.
02:05Thanks for watching.
02:06Assalamu Alaikum.