Sometimes you want your rows to be columns and columns to be rows.  But copying and pasting your data into this new format by hand is time consuming and full of opportunities for mistakes.  Excel gives you two options for flipping rows to columns, aka transposing your data.  This week we’ll cover the first.

Paste – Transpose

Excel 2007 & 2010

  1. Select the data you want to transpose and copy it (Ctrl + C to copy).
  2. Click on the first cell of the area where you want your transposed table.
  3. On the Home tab of the ribbon, click on the bottom half of the Paste button.
  4. Click on Transpose.

Excel 2003

  1. Select the data you want to transpose and copy it (Ctrl + C to copy).
  2. Click on the first cell of the area where you want your transposed table.
  3. Go to the Edit menu and select Paste Special.
  4. Check the Transpose box.
  5. Click OK.

The catch here is that you’re pasting data.  So if you update the original data, the transposed data will not update.  Any formulas you have that refer to cells within the table you’re transposing will update, but if you have a formula that refers to cells outside the table you’re transposing, your formula will refer to the wrong cells.

Tune in next week for a quick function that will transpose your data, and update if you change the original data.