How to Transpose Columns to Rows in Excel?

Select the cells you want to transpose

Copy the selected range

Click the destination cell

Right-click and choose Paste Special

Check Transpose

Click OK

Use the TRANSPOSE function if you want a dynamic result

Enter =TRANSPOSE(range) in the destination area

Press Enter in Excel 365 or Ctrl+Shift+Enter in older versions

Use Power Query if you need to transpose larger data sets

Use Paste Special values if you want only the transposed results without formulas

Suggested for You

Trending Today