vertical column to horizantal data

[NewsGuy]

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

 

[NewsGuy]

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

 

[Guest]

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.

 

[Peo Sjoblom]

Just note that if the column is longer than 256 rows it can't be transposed
so if the OP's set of data is 1000+ cells it won't work (at least not if he
wants to do it in one fell swoop)

 

[NewsGuy]

Big time thanks John!

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.