change cells contents from vertical to horizontal

[GailH]

I need to copy from one workseet the values in cells that are arranged
vertically into another worksheet and the values need to be arranged
horizontally. Can this be done? If so, how?

 

[Jacob Skaria]

Select the data to be copied>Copy>Select target cell>Right
click>PasteSpecial>select 'Transpose>OK

If this post helps click Yes

 

[GailH]

Perfect-thank you-you just saved me a ton of time.