taking numbers in vertical cells putting them in horizontal cells

  • Thread starter Thread starter jhawk22
  • Start date Start date
J

jhawk22

I'm looking for the formula that will take numbers in vertical cells putting
them in horizontal cells. I'm copying from a worksheet that has numbers
listed in columns and need to put them into cells that are in rows.

Thanks
 
Insert a new worksheet into the book. Go to the first sheet and select all
of the cells and use Edit --> Copy (or [Ctrl]+[C]) to copy them, go to the
second sheet and use Edit --> Paste Special with the "Transpose" box checked.
See if that doesn't do the trick for you.
 
By NOT formulas:
Select A1:A10 (or wherever the data are), click on the leftmost cell to
contain the results, use Paste Special & click the "Transpose" checkbox.
By Formulas:
If your range is 10 rows x 1 column, select 1 row x 10 columns, then enter
this formula via ctrl/shift/enter:
=TRANSPOSE(A1:A10)
 
Perfect. Thanks!


JLatham said:
Insert a new worksheet into the book. Go to the first sheet and select all
of the cells and use Edit --> Copy (or [Ctrl]+[C]) to copy them, go to the
second sheet and use Edit --> Paste Special with the "Transpose" box checked.
See if that doesn't do the trick for you.


jhawk22 said:
I'm looking for the formula that will take numbers in vertical cells putting
them in horizontal cells. I'm copying from a worksheet that has numbers
listed in columns and need to put them into cells that are in rows.

Thanks
Click to expand...
Click to expand...
 
Back
Top