Transpose into Excel Spreadsheet 1

[kmclane]

I need to out put the results of a query to an Excel spreadsheet, however, I need to make my first column be the first row. In other words, rahter than the data going across in dtasheet format, I need it to go down. Is there a way to accomplish this? If I could rotate the sheet 90 degrees to the right and turn the data also, that's what I need to do.
Thanks for any suggestions, Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[PHV]

When in Excel you may do a Copy/PasteSpecial transpose.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kmclane]

I gave you a star for this answer because I have a cert in Excel and didn't know that! It works great. Ken.

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg