vertical column to horizantal data
 

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

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

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

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)

--
Regards,

Peo Sjoblom


"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

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