Work has kept me busy, so this site was forgotten for a while. Now I feel guilty, like a parent who neglects their kids and then buys them stuff to make up for it. So, here’s a quick Excel tip, to make me feel better.

Lets say that you’ve listed, in a row, the months of the year.

Now that you’ve spend the time to type all twelve months (hopefully not becuase you can autofill the months in, but that’s another tip after I neglect you again) you realize that you would rather have the months in one column instead of a row.

A fast way to convert a row of data to a column of data is to use the Copy/Paste Special. Here’s how:

1. Copy your row of data (Jan through Dec).
2. Place the cursor onto the cell where you want to data to go.
3. Select Edit then Paste Special from the Menu.
4. The Paste Special dialog box will appear. Check the box for the Transpose option.

That’s it!