00:00Have you tried using transpose function in your Excel and you end up with this
00:04sort of an error? Well there's a workaround for it and this is how I do it.
00:07First you got to be aware of your table here so you got A to F which is about
00:11six rows and 11 columns so you're gonna have to highlight six rows 1 2 3 4 5 6
00:17all the way and 11 columns like this and then you're gonna start typing the
00:21formula equal transpose and then highlight the cell area that you want to
00:26transpose close parenthesis and here's the thing you have to press ctrl shift
00:31enter which converts that into an array and there you have it the transpose is
00:35working on a standalone Excel but if you're one of those lucky few people who
00:39have Microsoft 365 subscription you just go in here without having to count the
00:43column and row and selecting the area you just simply type equal transpose open
00:49parenthesis and select the data set table and then you simply hit enter and the
00:53table will be easily transposed without the need of mumbo-jumbo process of
00:57counting rows and columns and highlighting
Comments