How to Convert Rows to columns & Columns to Rows | Excel Tricks

In this tutorial, I demonstrate how to convert rows to column and column to rows in Excel. Excel has a tool called TRANSPOSE that converts rows to columns and vice-versa. TRANSPOSE is an option tool under PASTE SPECIAL function.