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.

Copy rows in excel

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

Paste-Special

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

Transpose

That’s it.See the result.

Rows to Column

The same steps applies for converting columns to rows.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>