Transpose multiple header into columns details

[jozpin]

Hi I have huge database with 3 rows header and I need to transpose it to columns for me to be able to create a header and detail tables

 

[alansidman]

Please show and example of before and after so that we have a clear understanding of your needs.

 

[jozpin]

Please show and example of before and after so that we have a clear understanding of your needs.

Than you so much for your reply.
Below is what I want..


[TABLE="width: 406"]
<colgroup><col><col span="3"><col></colgroup><tbody>[TR]
[TD="colspan: 5"]FROM[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]APPLE[/TD]
[TD]APPLE[/TD]
[TD]BANANA[/TD]
[TD]BANANA[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]GREEN[/TD]
[TD]GREEN[/TD]
[TD]YELLOW[/TD]
[TD]YELLOW[/TD]
[/TR]
[TR]
[TD]STORE NO.[/TD]
[TD]APPLE1[/TD]
[TD]APPLE2[/TD]
[TD]BANANA1[/TD]
[TD]BANANA2[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]TO[/TD]
[/TR]
[TR]
[TD]STORE NO[/TD]
[TD]DESC1[/TD]
[TD]DESC2[/TD]
[TD]DESC3[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]APPLE[/TD]
[TD]GREEN[/TD]
[TD]APPLE 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]BANANA[/TD]
[TD]YELLOW[/TD]
[TD]BANANA1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]BANANA[/TD]
[TD]YELLOW[/TD]
[TD]BANANA2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]APPLE[/TD]
[TD]GREEN[/TD]
[TD]APPLE 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]APPLE[/TD]
[TD]GREEN[/TD]
[TD]APPLE 2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]BANANA[/TD]
[TD]YELLOW[/TD]
[TD]BANANA1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]BANANA[/TD]
[TD]YELLOW[/TD]
[TD]BANANA2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]