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.