Spreadsheet Tips

How to Convert Columns into Rows in Excel

September 28, 2018
How to convert columns into rows in Excel

Stop! Don't re-type your data in Excel when you need to convert your columns into rows.

Use the transpose function instead. Copy your data, right click, and choose the transpose option from the menu. Just like that, your data will be flipped from columns into rows in your spreadsheet.