What is the purpose of the TRANSPOSE function or feature in Excel?

Microsoft Excel Medium

Microsoft Excel — Medium

What is the purpose of the TRANSPOSE function or feature in Excel?

Key points

  • TRANSPOSE changes the layout of data
  • It swaps rows with columns
  • This function is distinct from text formatting
  • It doesn't automatically convert formulas

Ready to go further?

Related questions