Transpose data in Excel

If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you quickly switch data from columns to rows or vice versa

Set up

  • Select the table you want to transpose
  • Select Copy
  • Select Paste Special (from the context menu)
  • Select the Transpose option
  • Done!