How To Change Row To Column In Excel?

Select the row you want to convert

Press Ctrl+C to copy it

Click the cell where you want the column to start

Right-click the cell

Choose Paste Special

Check Transpose

Click OK

If needed, use Paste Special as Values after transposing to keep only the data

Suggested for You

Trending Today