Transpose is a function which is used to convert a vertical range of cells to horizontal range or horizontal to Vertical range. The TRANSPOSE function must be entered as an in a range that has the same number of rows and columns, respectively, as the source has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet. Syntax ,this function apply only for range of cells it will not applicable for single cell.below we provided downlodable sample sheet & video for your understanding.
After watching video you can download below sample sheet. & it helps you to do practice more.please subscribe for more videos in our youtube channel.if you like our tutorial please share it on facebook & youtube below.
please leave your comments & suggestion in below form for better posts.