change cells contents from vertical to horizontal

  • Thread starter Thread starter GailH
  • Start date Start date
G

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?
 
Select the data to be copied>Copy>Select target cell>Right
click>PasteSpecial>select 'Transpose>OK

If this post helps click Yes
 
Back
Top