Big time thanks John!



"John Mansfield" wrote in message
...
NewsGuy,

You can use Excel's TRANSPOSE function to convert rows to columns or
columns
to rows. Assume you have the numbers 1, 2, and 2 in cells A1, A2, and A3.
Select the range A1:A3. Go to the Standard Toolbar and select Edit -
Copy.
Put your curser in cell C1. Go to the Standard Toolbar and select Edit -
Paste Special. In the Paste Special dialog box, add a check mark to the
Transpose option. Hit the OK button to complete the change.

----
Regards,
John Mansfield
http://www.pdbook.com


"NewsGuy" wrote:

In other words:
How can I change one long column into one long row?


"NewsGuy" wrote in message
...
I have been copying and pasting data to and from a column in Excel and
various other utilities like notepad. I need to have the vertical
data/cells (1,000+) in a horizontal format. Is there a quick easy way
to
do
this?

TIA