How to transpose multiple rows and columns in Excel in one shot

Using the Transpose feature of Paste Special in Excel can help you convert a row data into column, and column data into row.
But instead of transposing 1 single row or column, you may need to transpose multiple rows and columns together. This is very easily possible as well.
________________

SUBSCRIBE NOW!
@excelrush

Click this link to learn the most essentials of Excel
A Drop of Excel - Learn the most esse...

Click this link to learn more awesome functions in Excel
Learn Excel's Tricks