Hi to all,
I have excel like this[TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]21005-2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]S,M,L[/TD]
[TD]
[TABLE="width: 225"]
<tbody>[TR]
[TD]3,3,3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]21005-1[/TD]
[TD]S,M,L[/TD]
[TD]
[TABLE="width: 225"]
<tbody>[TR]
[TD]2,2,2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]S,M,L,XL[/TD]
[TD]1,5,3,0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
now i must trasform in colums like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]21005-2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]S
[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]21005-2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]M[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]21005-2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]L[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]21005-1[/TD]
[TD]S[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]21005-1[/TD]
[TD]M[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]21005-1[/TD]
[TD]L[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]S[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]M[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]L[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]XL[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 56px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 225"]
<tbody>[TR]
[TD]3,3,3[/TD]
[/TR]
</tbody>[/TABLE]
</body>How can do this? Thx
I have excel like this[TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]21005-2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]S,M,L[/TD]
[TD]
[TABLE="width: 225"]
<tbody>[TR]
[TD]3,3,3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]21005-1[/TD]
[TD]S,M,L[/TD]
[TD]
[TABLE="width: 225"]
<tbody>[TR]
[TD]2,2,2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]S,M,L,XL[/TD]
[TD]1,5,3,0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
now i must trasform in colums like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]21005-2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]S
[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]21005-2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]M[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][TABLE="width: 225"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]21005-2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]L[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]21005-1[/TD]
[TD]S[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]21005-1[/TD]
[TD]M[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]21005-1[/TD]
[TD]L[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]S[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]M[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]L[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]45699[/TD]
[TD]XL[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 56px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 225"]
<tbody>[TR]
[TD]3,3,3[/TD]
[/TR]
</tbody>[/TABLE]
</body>How can do this? Thx