vertical column to horizantal data

N

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
 
J

John Mansfield

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.
 
P

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)
 
N

NewsGuy

Big time thanks John!



John Mansfield said:
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.
Click to expand...
 
Top