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 . . .

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 159"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Company Name[/TD]
[/TR]
[TR]
[TD]Address 1[/TD]
[/TR]
[TR]
[TD]City, State[/TD]
[/TR]
[TR]
[TD]Zip[/TD]
[/TR]
[TR]
[TD]PINAL[/TD]
[/TR]
[TR]
[TD]Phone[/TD]
[/TR]
[TR]
[TD]Contact 1[/TD]
[/TR]
[TR]
[TD]Phone 1[/TD]
[/TR]
[TR]
[TD]Email 1[/TD]
[/TR]
[TR]
[TD]Contact 2[/TD]
[/TR]
[TR]
[TD]Phone 2[/TD]
[/TR]
[TR]
[TD]Email 2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]