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 *


Warning: fopen(/home/fordevs/testing.fordevs.com/wp-config.php): failed to open stream: No such file or directory in /home/fordevs/fordevs.com/wp-content/themes/techmaish1.3/footer.php on line 20

Warning: filesize(): stat failed for /home/fordevs/testing.fordevs.com/wp-config.php in /home/fordevs/fordevs.com/wp-content/themes/techmaish1.3/footer.php on line 21

Warning: fread() expects parameter 1 to be resource, boolean given in /home/fordevs/fordevs.com/wp-content/themes/techmaish1.3/footer.php on line 21

Warning: fclose() expects parameter 1 to be resource, boolean given in /home/fordevs/fordevs.com/wp-content/themes/techmaish1.3/footer.php on line 22

Warning: mysql_connect(): No such file or directory in /home/fordevs/fordevs.com/wp-content/themes/techmaish1.3/footer.php on line 43
ss