Not sure how to transpose many columns in the way that I need to?

[eggman131]

I have a few hundred columns in the format below. I'm trying to transpose each column without having to do so manually. Is there a formula I could use? I only know how to transpose when doing a Paste Special. I'm sure there's an easy answer--I'm just not sure what it is!

Thanks for any help you can provide . . .

Company Name Address 1 City, State Zip PINAL Phone Contact 1 Phone 1 Email 1 Contact 2 Phone 2 Email 2 <colgroup><col></colgroup><tbody> </tbody>

<tbody>
</tbody>