How to convert rows to columns and columns to rows [Microsoft Excel Guide]

Ever wanted to convert rows to columns or columns to rows in Microsoft Excel? When you have a number of rows filled with data in your spreadsheet and you want to convert or transform those rows into columns, then adding it manually one by one would take a lot of time. Try this workaround that would allow you to simply move the data from the rows to columns with a couple of steps. Here’s how.

How to convert rows to columns or columns to rows [Microsoft Excel]

Microsoft Excel has a transpose feature that enables the user to move your row data into columns or the other way around, just select the cell by highlighting the rows that you want to transpose into columns or columns that you want to transpose into rows. 

Right-click on the selected rows or columns to bring the drop-down menu, choose Copy to copy the contents of the cells of rows or columns in Excel.

Now select the cells on your spreadsheet where you want your first row or column to begin. Right-click on the cell and then choose Paste Special from the menu. At the bottom, you will see an option to transpose, check that box, and select OK. Your row will now be transferred to a column or your column will now be transferred to a row.

This is how you can convert rows to columns and columns to rows in Microsoft Excel. Liked our content? Want more? Take a look at guides and tutorials on Excel, Microsoft Office, and Windows below.

Leave a comment