How To Convert Row To Column In Excel?

Select the row you want to convert

Copy the selected row

Click the cell where you want the column to start

Right-click and choose Paste Special

Check Transpose

Click OK

Alternatively, use the formula `=TRANSPOSE(range)`

Press Enter if using a dynamic array version of Excel

Press Ctrl+Shift+Enter if using an older version of Excel

Suggested for You

Trending Today