How can i put some rows in colums?

[macro001]

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

 

[hiker95]

i'm not expert
sorry if u have lose your time with me
have nice day
goodbye

macro001,

In order to continue I would like to see your actual raw data workbook/worksheet (not flat text or a PNG display).

You can post your workbook/worksheet to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com