Transpose rows data to columns At Every "#" Row

[captec]

[TABLE="width: 1216"]
<colgroup><col><col><col><col span="2"><col span="2"><col></colgroup><tbody>[TR]
[TD="colspan: 7"]###################################################################################################################################[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Company[/TD]
[TD]Adrian Steel Co.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CompanyAddress[/TD]
[TD]Mailing[/TD]
[TD]906 James St.[/TD]
[TD][/TD]
[TD]Adrian[/TD]
[TD]MI[/TD]
[TD]49221[/TD]
[TD]USA[/TD]
[/TR]
[TR]
[TD]CompanyPhone[/TD]
[TD]Toll Free[/TD]
[TD]8006772726[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CompanyEmail[/TD]
[TD]tgoldmeyer@adriansteel.com[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CompanyWebsite[/TD]
[TD]www.adriansteel.com[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact[/TD]
[TD]Sales[/TD]
[TD]Employee[/TD]
[TD]Shawn[/TD]
[TD]Buckland[/TD]
[TD]Co-op[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact[/TD]
[TD]Sales[/TD]
[TD]Employee[/TD]
[TD]Todd[/TD]
[TD]Goldmeyer[/TD]
[TD]Marketing Manager[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact[/TD]
[TD]Billing[/TD]
[TD]Employee[/TD]
[TD]Todd[/TD]
[TD]Goldmeyer[/TD]
[TD]Marketing Manager[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]###################################################################################################################################[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Company[/TD]
[TD]ADSOKA[/TD]
[TD]Prefers contact by email only.[/TD]
[TD]Agency[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CompanyAddress[/TD]
[TD]Mailing[/TD]
[TD]1029 Washington Avenue S [/TD]
[TD][/TD]
[TD]Minneapolis[/TD]
[TD]MN[/TD]
[TD]55415[/TD]
[TD]USA[/TD]
[/TR]
[TR]
[TD]Contact[/TD]
[TD]Sales[/TD]
[TD]Employee[/TD]
[TD]Adriane[/TD]
[TD]Marten[/TD]
[TD]PR/Marketing Services[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ContactEmail[/TD]
[TD]Adriane@Adsoka.com[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact[/TD]
[TD]Production[/TD]
[TD]Employee[/TD]
[TD]Jason[/TD]
[TD]Inskeep[/TD]
[TD]Principal[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ContactPhone[/TD]
[TD]Toll Free[/TD]
[TD]6129100777[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ContactEmail[/TD]
[TD]jason@adsoka.com[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]###################################################################################################################################[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]