Use of Transpose option in Excel@shorts

Excel Tricks may need to official works - how to rotate data from Column to Row andVice-Versa by using TRANSPOSE option