How to Convert a Rows to Columns – Columns to Rows in Excel

There are times we need to convert excel rows to columns.Excel inbuilt has a option to do this in easy steps.

Rows to Columns

Step 1 : Select the all rows to be converted as columns and copy them.

Step 2 : Click in any empty cell and right click and select  Paste Special option from it.

Step 3 : A popup could come, from it check Transpose.

That’s it.See the result.

The same steps applies for converting columns to rows.