Copying vertically to horizontally

[msmit8]

Hi,

I have values on the same workbook that I need to copy from (horizontally) B15:Y15 to (vertically) B99:B122. What formula would be best for accomplishing this?

Thanks for your help!
Matt

 

[Jonmo1]

You can use the TRANSPOSE function..

Highlight B99:B122 and use
=TRANSPOSE(B15:Y15) <- do not press enter
Press CTRL + SHIFT + ENTER

 

[Joyner]

Hello, If you want just the values, you can Copy: Paste Special; Transpose. If you need the formula because the values will change, or be added to, you could look at the TRANSPOSE function or use a formula like this:

=INDEX($B$15:$Y$15,ROW(A1)) in cell B99 and copy down