I have a list of data in Row 1 that I would like to be displayed down Column A instead. Is there an easy way to transfer it from one to the other?

EUREKA!

Well, I figured it out in case anyone else is wondering.

First copy the data in the row (lets say A1 - A100). Then select the top of the column that you want to paste to (lets say B2... you cannot select A1 as it will overlap and cause an error).

Then under Paste Special (or the Paste drop down for Excel 2007) select Transpose.

Viola!

Kudos, it's always great when you figure out your own questions, before anybody even has a chance to read...

I am waiting on another question though?

I am waiting on another question though?

What question is that?