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