How to Flip Columns and Rows in Excel?

Select the range of cells you want to transpose

Copy the selected cells

Click the destination cell where you want the transposed data to start

Right-click and choose Paste Special

Select Transpose

Click OK

Or use the TRANSPOSE function

Select an empty range with the transposed size

Type =TRANSPOSE(original_range)

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

Suggested for You

Trending Today