Transposing Data in Excel

[ntrew]

Is there any way of getting the information in column A to print in the first row.<br><br>i.e.<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column A<br>row 1&nbsp;&nbsp;&nbsp;&nbsp;Name:<br>row2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Address:<br>row3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Tel:<br><br>changed to:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column B&nbsp;&nbsp;Column C&nbsp;&nbsp;&nbsp;Column D<br>Row 1:&nbsp;&nbsp;&nbsp;Name:&nbsp;&nbsp;&nbsp;&nbsp;Address:&nbsp;&nbsp;&nbsp;Tel:<br><br>Thank you for your help.<br><br>Nicky Trew<br>

 

[Dreamboat]

Select data and copy. Go to new sheet, cell A1. Hit Edit-Paste Special-Transpose. Should work. <p> <br><a href=mailto:techsupportgirl@home.com>techsupportgirl@home.com</a><br><a href=

http://www.wedomanuals.com>

</a><br>